I have very (from my point of view) strange error while trying to restore SQL server DB from a series of filegroup backups.
Here is my corrent config:
I have DB with 2 files 2 filegroups and 1 log file.
1st group (called PRIMARY is not read-only and contains my current data).
2nd is (called HISTORICAL) is read-only.
I also have partitioning.
Because of lack of space I make following:
- After some service operations (moving data from PRIMARY to HISTORICAL FG) I make FULL Database backup (each month).
- After that make FULL backup of both groups and then I make log backup.
- I make PRIMARY FG full backup each night.
- I make PRIMARY FG differential backup each hour.
- I make t-log backup every 15 minutes.
My strategy is to minimize space required for backups.
In case of faliour I wil restore FULL backup from beginning of the month. After that I will restore HISTORICAL backup (which is only one for each month). After that I will restore full PRIMARY FG backup from desired time (I am not sure if I have to restore PRIMARY FG backup after FULL DB backup). As last step I will restore t-log backup and return DB in operational state (if needed).
I do that operations in the past. Right now I receive error that the LSN that I tried to restore is too recent. Why this happends?