Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
winman
Starting Member
26 Posts |
 Posted - 2013-01-16 : 07:18:22
|
| 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 asFile '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
212 Posts |
Posted - 2013-01-18 : 00:02:41
|
| 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. |
 |
|
|
|
|
|
Restoring file group error