如何在MS SQL Server 2012上还原MS SQL Server 2005（.bak）文件 [英] how to restore MS SQL Server 2005(.bak) file on MS SQL Server 2012

问题描述

我正在使用Windows 8.我想在SQL Server 2012上恢复2005备份文件.SQL Enterprise Manager无法安装在我的计算机上。帮助我。

解决方案

在选项选项卡中，您有一个复选框，表示关闭与目标数据库的现有连接。你检查过那个吗？

 使用这个查询：
 
  RESTORE   DATABASE  [SouthWind] 
  FROM   DISK  = '  C：\Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ South.BAK' 
  WITH  REPLACE，
 MOVE < span class =code-string>'  SouthWind_Data'  TO  '  C：\Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ Data \ SouthWind_Data.MDF'，
 MOVE '  SouthWind_Log'  TO  '  C：\Program Files\Microsoft SQL Server \ MSSQL.1 \ MSSQL \Data \ SouthWind_Log.LDF' 
 
 其中 FromDisk   其中 .bak 文件    服务器B 和 MOVE指定的位置数据和 log 文件 

I am using Windows 8. I want to restore 2005 back up file on SQL Server 2012. SQL Enterprise Manager can't install in my computer. Help Me.

解决方案

In options tab you have a check box that says close existing connections to destination datatbase. Have you checked that one?

Use this query:

RESTORE DATABASE [SouthWind]
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\South.BAK'
WITH REPLACE,
MOVE 'SouthWind_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SouthWind_Data.MDF',
MOVE 'SouthWind_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SouthWind_Log.LDF'

where FromDisk is where the .bak file is kept on Server B and MOVE specifies the location of the data and log file.

这篇关于如何在MS SQL Server 2012上还原MS SQL Server 2005（.bak）文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！