How can we help you today? How can we help you today?

Restore to a Smaller Drive

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
davebublitz
0

Comments

1 comment

Sort by
  • petey
    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.
    petey
    0

Add comment

Please sign in to leave a comment.