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_pri mary.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_fgp 1.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_fgp 2.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
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_pri mary.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_fgp 1.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_fgp 2.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