By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

FILEGROUP BACKUP/RESTORE

P: n/a
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

May 17 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.