469,648 Members | 1,581 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

FILEGROUP BACKUP/RESTORE

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
0 1888

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by newbiegca_sqlsever2000 | last post: by
reply views Thread by Louis | last post: by
2 posts views Thread by si.downes | last post: by
6 posts views Thread by Eric Herber | last post: by
4 posts views Thread by Hardy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.