August 18, 2006 at 3:33 am
Hi, I was wondering whether anyone knew a way to resize filegroups in a backup device, or prior to restore. I have a client with a database that is going to grow fast to 160GB, so have sized filegroups to this on deployment. At the moment, there is about 200MB of data in it, and they want a soft copy of this to use as a training database. The server for training doesn't have 160GB on it, but has plenty to run the database with small amounts of data. I was wondering if there was a way i could do a database copy or restore that ignored the file group sizes.
Thanks,
Chris
August 18, 2006 at 4:22 am
Chris
You could shrink your database, back it up, and then expand it back to 160GB again. I don't recommend that, though, because it may cause fragmentation on your disk.
Probably best to create an empty database on the same server and use DTS to copy all objects into it. You can then back up the new database and restore it on the training server.
John
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply