Click here to Skip to main content
15,917,177 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hello .
i backup my database .
.bak file's size is 12 MB.
but when i want to restore it into aonther server the following error is showed:
TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore of database 'TaskManager' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'E:\' to create the database. The database requires 36793942016 additional free bytes, while only 19379011584 bytes are available. (Microsoft.SqlServer.SmoExtended)

OK
------------------------------


how can i solve this problem?
Posted
Comments
[no name] 1-Jun-14 8:10am    
Pick a drive that has sufficient free space or free up space on the E drive.
aliwpf 1-Jun-14 8:12am    
i do it. but my problem doesn't solve.
[no name] 1-Jun-14 8:15am    
If you actually did it, then your problem would have been solved.
Mike Meinz 1-Jun-14 8:23am    
The error message says that it needs almost 37GB to restore your database. Make sure that the disk that you are restoring to has more than 37GB free space. You might want to Defrag that disk before attempting the install.

1 solution

A quick google suggests
http://stackoverflow.com/questions/15348272/insufficient-disk-space-when-restoring-a-small-backup[^] - it's talking about a 23Mb file needing 6Gb, while you are a 12Mb needing 37Gb.

It's worth trying the "sizes" thing to see what you are talking about, and also shrinking the DB before trying the restore: it may be that the current file is enormous and very, very empty!
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900