March 19, 2008 at 1:38 pm
Our database is about 12 GB on a 40 GB disk with 19 GB of free space. W
What is a reasonable rule-of-thumb for space required to restore the database? Is 2 or 3 times the size of the database really required?
Thank you for any assistance.
March 19, 2008 at 1:49 pm
space required =
size of .mdf + size of all .ndf (if present) + size of .ldf + size of .bak file
The .bak will almost always be smaller than the size of the .mdfs and .ndfs, use sp_spaceused or properties of databases in EM to predict a backup size
---------------------------------------------------------------------
March 20, 2008 at 8:57 am
If space is at a premium, you might want to consider using a third party backup tool that can compress backups and restore from compressed files.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
March 20, 2008 at 9:38 am
Thank you for your help. The restore worked when I freed up enough space. My backup is only a few percent smaller then my database.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply