I have two similar databases with identical filegroups(primary,secondary) but on different drives.
At one-point in time both the databases are in sync.
I created on a secondary filegroup and populated several thousand rows to grow the filesize
Took a backup of secondary filegroup and when I try to restore the secondary filegroup back on the secondary server I get the following error:
RESTORE DATABASE RaziTest -- secondary database
FILEGROUP = 'RaziTest_FileGRP2' --secondary filegroup
FROM DISK ='H:\sqldata\TempRazi\RaziTest_FileGRP2.BAK' --backup of secondary filegroup from primary server
Msg 3116, Level 16, State 2, Line 1
The supplied backup is not on the same recovery path as the database, and is ineligible for use for an online file restore.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any help in getting around this is appreciated.