通过还原创建数据库 - 问题 [英] Creating a DB by restore - problems
问题描述
嗨:
我有一个文件,我被告知是从某个地方的
服务器进行的SQL Server备份。该文件大小约为200MB
我正在尝试使用RESTORE在本地服务器上创建数据库。我用
创建了备份设备,并将其与备份名称等关联起来。
将文件复制到备份目录。
当我运行RESTORE命令时,查询分析器告诉我数据库
需要31 GB的空间并且RESTORE中止。我已经尝试了几次
次,每次都得到相同的结果。
有人见过这样的事吗?是否有另一种方法可以使用备份文件在服务器中创建一个
数据库?
我在运行
Windows Server 2003操作系统。
我将不胜感激任何帮助/建议。
Waz
恢复的数据库与原始数据库的大小相同,因此您需要
用于恢复的可用空间量。您可以确定RESTORE FILELISTONLY所需的
空间量。例如:
RESTORE FILELISTONLY
来自DISK =''C:\ MyBackupFile.bak''
请注意,备份文件可能要小得多,因为未使用的数据不会备份
页面。
-
希望这有帮助。
Dan Guzman
SQL Server MVP
< Eg ******* *@Last.com>在消息中写道
news:mb ******************************** @ 4ax.com ...嗨:
我有一个文件,我被告知是从某个地方的服务器进行的SQL Server备份。该文件大小约为200MB
我正在尝试使用RESTORE在本地服务器上创建数据库。我创建了备份设备,将其与备份名称等相关联,
将文件复制到备份目录中。
当我运行RESTORE命令时,查询分析器告诉我数据库需要31 GB的空间,RESTORE中止。我已经尝试了几次,每次都得到相同的结果。
任何人见过这样的事情?是否有另一种方法可以使用备份文件在服务器中创建数据库?
我在运行Windows Server 2003操作系统的计算机上运行SqlServer 2000,Developer Edition。 br />
我将不胜感激任何帮助/建议。
Waz
2005年5月25日星期三23 :55:55 GMT,Dan Guzman
< gu ****** @ nospam-online.sbcglobal.net>写道:
恢复的数据库与原始数据库的大小相同,因此您需要有足够的可用空间来进行恢复。您可以使用RESTORE FILELISTONLY确定所需的空间量。例如:
RESTORE FILELISTONLY
FROM DISK =''C:\ MyBackupFile.bak''
请注意,备份文件可能会小得多,因为未使用数据
页面没有备份。
Dan:
感谢您的回复。 RESTORE FILELISTONLY说数据文件
需要1.2 gig,但日志文件需要31 gig。如何在没有日志的情况下恢复
数据,或者我可以吗?
谢谢,Waz
< blockquote>
< Eg ******** @ Last.com>在消息中写道
news:mb ******************************** @ 4ax.com ...
嗨:
我有一个文件,我被告知是从某个地方的服务器进行的SQL Server备份。该文件大小约为200MB
我正在尝试使用RESTORE在本地服务器上创建数据库。我创建了备份设备,将其与备份名称等相关联,
将文件复制到备份目录中。
当我运行RESTORE命令时,查询分析器告诉我数据库需要31 GB的空间,RESTORE中止。我已经尝试了几次,每次都得到相同的结果。
任何人见过这样的事情?有没有其他方法可以使用备份文件在服务器中创建一个数据库?
听起来他们可能有一个巨大的数据库,只包含200 MB的
数据。
其他比havnig 31 GB免费,不知道你能做什么。
你能发布一份RESTORE FILEHEADERSONLY命令的结果吗?
我是在运行Windows Server 2003操作系统的计算机上运行SqlServer 2000,开发人员版。
我将不胜感激任何帮助/建议。
Waz
Hi:
I have a file that I have been told is a SQL Server backup from a
server somewhere. The file is about 200MB in size
I am trying to create the database on my local server using RESTORE. I
created the backup device, associated it with a backup name etc.,
copied the file into the backup dir.
When I run the RESTORE command, Query Analyzer tells me the database
needs 31 GB of space and the RESTORE aborts. I''ve tried this several
times, get the same result every time.
Anybody ever seen anything like this? Is there another way to create a
DB in a server using a backup file?
I am running SqlServer 2000, Developer edition on a machine running
Windows Server 2003 OS.
I would appreciate any help/suggestions.
Waz
A restored database is the same size as the original database so you''ll need
that amount of free space for the restore. You can determine the amount of
space required with RESTORE FILELISTONLY. For example:
RESTORE FILELISTONLY
FROM DISK=''C:\MyBackupFile.bak''
Note that the backup file may be considerably smaller since unused data
pages are not backed up.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<Eg********@Last.com> wrote in message
news:mb********************************@4ax.com...Hi:
I have a file that I have been told is a SQL Server backup from a
server somewhere. The file is about 200MB in size
I am trying to create the database on my local server using RESTORE. I
created the backup device, associated it with a backup name etc.,
copied the file into the backup dir.
When I run the RESTORE command, Query Analyzer tells me the database
needs 31 GB of space and the RESTORE aborts. I''ve tried this several
times, get the same result every time.
Anybody ever seen anything like this? Is there another way to create a
DB in a server using a backup file?
I am running SqlServer 2000, Developer edition on a machine running
Windows Server 2003 OS.
I would appreciate any help/suggestions.
Waz
On Wed, 25 May 2005 23:55:55 GMT, "Dan Guzman"
<gu******@nospam-online.sbcglobal.net> wrote:
A restored database is the same size as the original database so you''ll need
that amount of free space for the restore. You can determine the amount of
space required with RESTORE FILELISTONLY. For example:
RESTORE FILELISTONLY
FROM DISK=''C:\MyBackupFile.bak''
Note that the backup file may be considerably smaller since unused data
pages are not backed up.
Dan:
Thanks for your response. RESTORE FILELISTONLY says the data file
needs 1.2 gig but the log file needs 31 gig. How can I restore the
data without the log, or can I?
Thanks, Waz
<Eg********@Last.com> wrote in message
news:mb********************************@4ax.com...Hi:
I have a file that I have been told is a SQL Server backup from a
server somewhere. The file is about 200MB in size
I am trying to create the database on my local server using RESTORE. I
created the backup device, associated it with a backup name etc.,
copied the file into the backup dir.
When I run the RESTORE command, Query Analyzer tells me the database
needs 31 GB of space and the RESTORE aborts. I''ve tried this several
times, get the same result every time.
Anybody ever seen anything like this? Is there another way to create a
DB in a server using a backup file?
Sounds like they may have had a huge database that only contained 200 MB of
data.
Other than havnig 31 GB free, not sure what you can do.
Can you post the results of a RESTORE FILEHEADERSONLY command?
I am running SqlServer 2000, Developer edition on a machine running
Windows Server 2003 OS.
I would appreciate any help/suggestions.
Waz
这篇关于通过还原创建数据库 - 问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!