February 22, 2012 at 11:21 pm
Hi Friends,
I have a backup of one database physically.database suddenly crashed now I need to restore that database..so While restoring that database,some of the objects are waste I have to avoid that objects how will I do that...Give me solution in detailed way friends.....
with Regards,
Er.karthikn
February 23, 2012 at 2:11 am
what do you mean waste?
corrupted? no longer needed? been dropped?
you cant avoid restoring an object, if the backup contains 50 objects it needs to restore 50 objects
February 23, 2012 at 2:43 am
Er.karthikn (2/22/2012)
Hi Friends,I have a backup of one database physically.database suddenly crashed now I need to restore that database..so While restoring that database,some of the objects are waste I have to avoid that objects how will I do that...Give me solution in detailed way friends.....
with Regards,
Er.karthikn
The backup file will restore all the objects that it has backed up. You can not avoid it while restoring. You can only drop those objects once you have restored the database succesfully.
February 23, 2012 at 2:47 am
If your database was divided into multiple filegroups and all the objects you don't want to restore were in one filegroup (not the primary filegroup), then you can restore all but that filegroup. If the DB was a single filegroup then you have to restore it all.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply