This is a discussion on FILEGROUP BACKUP/RESTORE within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, I have a database were all the indexes are in a seperate filegroup a few large tables are ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I have a database were all the indexes are in a seperate filegroup a few large tables are in a seperate filegroup. We take backup at different times and I have backup of primary, two filegroup and then transaction logs. The backup was successful when I restore the same backup it is erroring out with this error: Server: Msg 3135, Level 16, State 2, Line 1 The backup set in file 'E:\Manual Backup\test_primary.bak' was created by BACKUP DATABASE...FILE=<name> and cannot be used for this restore operation. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Server: Msg 3135, Level 16, State 2, Line 13 The backup set in file 'E:\Manual Backup\test_fgp1.bak' was created by BACKUP DATABASE...FILE=<name> and cannot be used for this restore operation. Server: Msg 3013, Level 16, State 1, Line 13 RESTORE DATABASE is terminating abnormally. Server: Msg 3135, Level 16, State 2, Line 21 The backup set in file 'E:\Manual Backup\test_fgp2.bak' was created by BACKUP DATABASE...FILE=<name> and cannot be used for this restore operation. Server: Msg 3013, Level 16, State 1, Line 21 RESTORE DATABASE is terminating abnormally. Thanks in advance Raj |