September 29, 2010 at 3:37 pm
Okay.. I just reviewed my new database and I see that the Second File Group is offline, same thing with the tables that are located in the Second File Group. Also, I see that the size of the database is smaller than the original one.
so this Partial Backup/Restore works well.
I was trying to get a smaller reserve size of the database because the size is big. The original database is around 50GB in total-size and only 10MB are between the 2 file groups. When I do the partial restore I see that the Database Size (with the reserve space) is still 50GB, but only 5GB are in space of the partial restore, which is good. But, Is anyway I can have a smaller reserve space? I will need to repeat this kind of process once a month
Even if the tables are offline 'cause the filegroup is offline, we dont need them in this restore. What is the best practice for this case?
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply