还原数据库失败 [英] Restore database is failed
本文介绍了还原数据库失败的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好。
我备份我的数据库。
.bak文件的大小是12 MB。
但是当我想将它恢复到其他服务器时,会显示以下错误:
标题:Microsoft SQL Server Management Studio
------------------------------
恢复数据库'TaskManager'失败。 (Microsoft.SqlServer.Management.RelationalEngineTasks)
------------------------------
附加信息:
System.Data.SqlClient.SqlError:磁盘卷'E:\'上没有足够的可用空间来创建数据库。该数据库需要36793942016个额外的空闲字节,而只有19379011584个字节可用。 (Microsoft.SqlServer.SmoExtended)
OK
------------------------------
如何解决这个问题?
解决方案
快速谷歌建议
http://stackoverflow.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://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!
这篇关于还原数据库失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文