Hi, I have query about space/size requirements in SQL servers. Assume i have a .bak file ( back up of site collection) of 100GB size and my SQL server has 130GB space.  Is this 130GB space in SQL would enough to restore 100GB of sitecollection backup ? Does it require twotimes more than backupsize  of space in SQL to restore??  ie 200GB required ? Can you please clarify.

Is 130GB space in SQL would enough since my .bak file is 100GB   ( My backup .bak is in another location ).

or

is 200GB space required in SQL since my .bak file is 100GB Please clarify.

Hi Cnivass,

The .bak file is about the size of the actual data in the database, but when you restore the database, it will also include the database files, such as log files.

And it depends on size of the database metadata files and the actual data that how much space you need to restore a database.

So I am not sure if 200GB is enough for you as the size of the database metadata files is not clear.

You can shrink the database before backup and it will need less space.

More references:

http://serverfault.com/questions/79785/excessive-space-required-for-sql-server-bak-restore

http://dba.stackexchange.com/questions/34248/restore-backup-fails-not-enough-disk-space

http://dba.stackexchange.com/questions/14682/restore-bak-file-to-smaller-mdf-and-ldf-database-files

Thanks,

Victoria