I have a database say DB1 having 2 data files and 1 log Files.
My objective is to restore a file of a DB1 using the backup ( Only that specified file will be backed up and restored to another database).
For that what I did ,
1. backed up the file (say mdf) using file and filegroup option.
2. tried to restore the file in another database DB2, When I did this I got an error that File 2 was not backed up.
Please advise how to accomplish this task.
Thanks in advance
Ranjith Kumar Mohandas
View Complete Post