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.
| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
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 |
|
|
|
|
|
|
Restore DB Without the WhiteSpace