Restoring filegroups in MS SQL 2008
Posted on 2011-03-24
I would like to know how to restore specific Filegroups from a a filegroup backup file in sql server 2008.
i have followed books online's tutorial step by step, yet nothing seems to work.
This is the exception i cannot seem to get figured out...
File 'Tester2' was not backed up in file 1 on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQL2008R2\MSSQL\Backup\Primary.bak'. The file cannot be restored from this backup set.
RESTORE DATABASE is terminating abnormally. (.Net SqlClient Data Provider)
Any help would be a life saver,
Thank you in advance.