Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Restore DB Without the WhiteSpace

Author  Topic 

Analyzer
Posting Yak Master

115 Posts

Posted - 2014-03-18 : 12:05:38
New prod DB (60GB data/60GB whitespace) needs to be backed up and sent off site to vendor. Vendor has complained about the DB size and requested we remove whitespace.

Naturally we are reluctant to shrink a prod DB. Is there a new function yet with ss2012 that allows a RESTORE while removing white space? Remember something around you can restore the T-Logs on target much smaller than source backup.

Thanks for any advice you can give.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-03-18 : 12:22:16
No such function exists in any versions of SQL Server. Restore the database to a test machine, perform the shrink and then backup the database, preferably compressed or compress the backup file.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Analyzer
Posting Yak Master

115 Posts

Posted - 2014-03-19 : 04:03:09
Thanks for the confirmation Tara. Must had got confused with the T-Log restore features in 2012. Looks like I better get shrinking
Go to Top of Page
   

- Advertisement -