SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Restoring file group error		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

winman
Starting Member

26 Posts
Posted - 01/16/2013 :  07:18:22  Show Profile  Reply with Quote

I have created the file group for my database.First i took backup of individual file group(mdf and ndf) then I tried to restore primary file group but i got error as
File 'testnvt2' was not backed up in file 1 on device 'D:vtprimary.bak'. The file cannot be restored from this backup set.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3144)

then i tried to restore only secondary file group, but again i got the error as
File 'regSQL_dat' was not backed up in file 1 on device 'D:vtndf.bak'. The file cannot be restored from this backup set.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3144)

So why this error comes? How exactly to backup and restore only a single group or restore file groups?

prett
Posting Yak Master

USA
161 Posts
Posted - 01/18/2013 :  00:02:41  Show Profile  Reply with Quote
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.
Edited by - prett on 01/18/2013 00:03:08
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000