August 31, 2010 at 10:03 pm
Hi experts,
I created a database having differnt filegroup and restored a full backup of that database to another one.Later I took backup of only a particular filegroup ..Now how can I restore that backup? I mean the backup of that particular filegroup.
When i tried getting error
File 'Test_dat' was not backed up in file 1 on device 'G:\diff_filegroup_sec.bak'. The file cannot be restored from this backup set.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3144)..
September 1, 2010 at 12:45 am
You need to restore primary first (from a filegroup backup of primary or a full db backup) then you can restore the backup of the other file group. You'll also need log backups to bring them to a consistent point in time.
Please read through the sections on backup and restore of filegroups in Books Online
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 1, 2010 at 12:52 am
Is it possible to restore using a backup having both primary & secondary filegroup backup??
I tried restoring backup of primary filegroup alone but its giving error that other files are not backed up
September 1, 2010 at 12:56 am
Yes.
Please, please, please read up on this in BoL.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 1, 2010 at 1:27 am
Sure Gail Thanks 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply