Restore DB problem

[Jmichael2468]

I have a 17 gig SQL 2000 database to restore on a 31 gig drive, but I am getting an error stating there isn't enough space on the disk to do the restore. Can someone explain to me why this is happening? I have looked at the file size of the database and the t-log where it was backed up from and the free space on the target drive, so I know that the db is 17 gig and the free space is 31 gig.

 

[SQLBill]

So, the db and tlog together is only 17GB. As I understand it, when you restore SQL Server databases it actually takes up MORE space than the actual files. That extra space is recovered after everything is complete. Why does it do this? Because SQL Server needs to know what is done and what is being done in case it needs to rollback the restore.

The extra space can actually be 1 1/2 times the size of the database being restored.

Solution: Detach the database. Copy the .mdf and .ldf files to the new location. Attach the database.

-SQLBill