恢复数据库sql server标准 [英] Restore database sql server standard

问题描述

我有一个sql express 2005数据库，它是在另一台服务器上创建的。我希望将该数据库恢复到我的sql server standard 2005，但到目前为止我还没有成功。我尝试了GUI还原选项失败，所以我按照本网站的查询指南 http：//www.sqlteam .com / forums / topic.asp？TOPIC_ID = 40841 [ ^ ]

按照说明操作但仍然无法恢复我的数据库..



这里是查询

  RESTORE  FILELISTONLY 
  FROM   DISK  = '  E：\ bari \latestDtNEt \ millat_tractors_LTD.bak' 

结果

< pre lang =vb> millat_tractors C：\Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \DATA\millat_tractors_LTD.mdf D PRIMARY 41943040 35184372080640 1 0 0 88142C8F-19A6-4013-86C0-84970A84B80E 0 0 41287680 512 1 NULL 20000000034100037 34F0C4FF-F9D0-467D-B9AF-652CA99F2C70 0 1
millat_tractors_log C：\Program Files \ Microsoft Microsoft SQL Server \ MSSQL.1 \ MSSQL \DATA\millat_tractors_LTD_1.ldf L NULL 48758784 2199023255552 2 0 0 D9911775-121F-4B01-A7C0-21EABDF234B2 0 0 0 512 0 NULL 0 00000000-0000-0000-0000-000000000000 0 1

< b>

恢复查询

  RESTORE   DATABASE  millat_tractors_LTD 
  FROM   DISK  = '  E：\ bari\latestDtNEt\millat_tractors_LTD.bak' 
  WITH  REPLACE，MOVE '  millat_tractors'  TO  '  C：\Program Files \微软SQL Server \ MSSQL.1 \ MSSQL \DATA \ millat_tractors_LTD.mdf'，
 MOVE '  millat_tractors_log'  TO  '  C：\Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \DATA\millat_tractors_LTD_1.ldf' 

这就是我得到的错误

消息5133，级别16，状态1，行1 
文件的目录查找C： \Program Files \ Microsoft SQL Server \MSSQL.1 \ MSSQL \ DATA \ millat_tractors_LTD.mdf因操作系统错误3而失败（系统找不到指定的路径。）。 
消息3156，级别16，状态3，行1 
文件'millat_tractors'无法恢复为'C：\Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \DATA \millat_tractors_LTD.mdf。使用WITH MOVE标识文件的有效位置。 
消息5133，级别16，状态1，行1 
文件的目录查找C：\Program Files \ Microsoft Microsoft SQL Server \ MSSQL.1 \ MSSQL \DATA\millat_tractors_LTD_1 .ldf因操作系统错误3而失败（系统找不到指定的路径。）。 
消息3156，级别16，状态3，行1 
文件'millat_tractors_log'无法恢复为'C：\Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \DATA \millat_tractors_LTD_1.ldf。使用WITH MOVE标识文件的有效位置。 
消息3119，级别16，状态1，行1 
在规划RESTORE语句时发现了问题。以前的消息提供详情。 
消息3013，等级16，状态1，行1 
 RESTORE DATABASE异常终止。

thankyou

解决方案

检查：C：\Program Files \ Microsoft SQL Server与新服务器相同。

RESTORE DATABASE [C] FROM DISK ='D：\\Inventory.bak'with RECOVERY，

移动'Inventory_Data'

到'C：\\Program Files \\ Microsoft SQL Server \\MSSQL \\ data \\c_Data.MDF'，

移动'Inventory_Log'

TO

'C：\\Program Files \\ Mysoftoft SQL Server \\ MSSQL \\Data\\c_Log.LDF'，

REPLACE， stats = 1









只有你需要关心的事情，恢复数据库不是在MS SQL SERVER中创建的，

在我的情况下查询运行后它应该创建一个名为[C]的新数据库

并在[C：\\Program Files \\Microsoft SQL Server \\ MSSQL \\Data\\]

的路径创建其文件

i have a sql express 2005 database which was created on another server.i want to restore that database to my sql server standard 2005 but i have so far have been unsuccessful. i tried the GUI restore option it failed so i followed the query guide from this website http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=40841[^]
followed the instructions but still could not restore my database..

here is the Query

RESTORE FILELISTONLY
FROM DISK = 'E:\bari\latestDtNEt\millat_tractors_LTD.bak'

result

millat_tractors C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD.mdf    D   PRIMARY 41943040    35184372080640  1   0   0   88142C8F-19A6-4013-86C0-84970A84B80E    0   0   41287680    512 1   NULL    20000000034100037   34F0C4FF-F9D0-467D-B9AF-652CA99F2C70    0   1
millat_tractors_log C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD_1.ldf  L   NULL    48758784    2199023255552   2   0   0   D9911775-121F-4B01-A7C0-21EABDF234B2    0   0   0   512 0   NULL    0   00000000-0000-0000-0000-000000000000    0   1

restore query

RESTORE DATABASE millat_tractors_LTD
FROM DISK = 'E:\bari\latestDtNEt\millat_tractors_LTD.bak'
WITH REPLACE, MOVE 'millat_tractors' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD.mdf',
MOVE 'millat_tractors_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD_1.ldf'

and this the error i got

Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD.mdf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'millat_tractors' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD_1.ldf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'millat_tractors_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\millat_tractors_LTD_1.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

thankyou

解决方案

Check: C:\Program Files\Microsoft SQL Server is the same for the new server.

RESTORE DATABASE [C] FROM DISK = 'D:\\Inventory.bak' WITH RECOVERY,
MOVE 'Inventory_Data'
TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL\\Data\\c_Data.MDF',
MOVE 'Inventory_Log'
TO
'C:\\Program Files\\Microsoft SQL Server\\MSSQL\\Data\\c_Log.LDF',
REPLACE, stats =1




Only thing you have to care, restore database is not created in MS SQL SERVER,
In My case After query run it should create new database with Name [C]
and create its file at path of [C:\\Program Files\\Microsoft SQL Server\\MSSQL\\Data\\]

这篇关于恢复数据库sql server标准的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！