.bak文件中的数据库还原 [英] DATABASE RESTORE FROM .bak File

问题描述

我有一个大小为20 GB的.bak文件.

逻辑文件的实际大小约为20GB.但是分配的最大大小为300GB.

尝试还原时，出现大小错误.
我的磁盘上有100GB的可用空间.

请问我是否可以更改.bak文件中文件的初始/最大大小?

I have a .bak file of size 20 GB.

The actual size of logical files is ~20GB. But the max size allocated is 300GB.

When I try to restore, I''m getting the size error.
I have 100GB free space on my disk.

Could be please let me know if its possible to change the initial/max size of files in .bak file ?

Thanks in advance.

推荐答案

1)仅从磁盘=> E:\ backup \ ter.bak''恢复标头
-它将显示兼容性级别和软件版本

2)仅从磁盘=``E:\ backup \ ter.bak''恢复Filelist仅
-它会显示mdf和ldf文件的总空间.如果它显示更多的空间，则必须将其释放.

3)从磁盘="E:\ backup \ ter.bak''还原verifyonly -检查备份是否有效

4)仅从磁盘=> E:\ backup \ ter.bak''恢复Label
-检查媒体相关信息

1)Restore headeronly from disk =''E:\backup\ter.bak''
--it will show compatibilty level and software version

2)Restore Filelistonly from disk =''E:\backup\ter.bak''
-- it will show total mdf and ldf file space .if it is showing more space then you have to make it free.

3)Restore verifyonly from disk =''E:\backup\ter.bak''
--check backup is valid

4)Restore Labelonly from disk =''E:\backup\ter.bak''
-- check media related information

这篇关于.bak文件中的数据库还原的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！