快速谷歌建议

http://***.com / questions / 15348272 /磁盘空间不足 - 恢复小型备份 [ ^ ] - 它正在讨论需要6Gb的23Mb文件，而你需要37Gb的12Mb文件。



值得尝试大小的东西，看看你在说什么，并在尝试恢复之前缩小数据库：可能是当前文件非常非常非常空！

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?

A quick google suggests
http://***.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!