Restore to a Smaller Drive

davebublitzdavebublitz Posts: 12 Bronze 2
edited October 11, 2010 10:06PM in SQL Backup Previous Versions
If I have a 2 TB database with 500 GB of data can I restore the database to a server with only 1 TB of free disk space? Last time I tried this it failed because there was not 2 TB of free space to build the empty files. I want to restore the entire database to a test environment, not just a few of the objects.

Thanks
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    No, it isn't possible. SQL Server needs to recreate all the database files with the original sizes.

    Instead, take a look at SQL Virtual Restore, as it allows you to use a database backup as if it was a live database. More details here.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.