如何恢复SQL Server 2005数据库的.bak文件 [英] How to restore .bak file of SQL Server 2005 database

问题描述

我手动创建了我的SQL Server 2005数据库 Kolkata_Dental 的备份文件，即Kolkata_Dental.bak。现在我想完全格式化我的机器，在完全格式化我的PC后，将从我的机器上卸载SQL Server 2005。重新安装SQL Server 2005后，我想从Kolkata_Dental.bak文件中恢复并恢复所有数据。怎么做我不知道。请帮忙。

注意： - Kolkata_Dental.bak文件保存在目录C中：\\ProgramFiles \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ Backup \ Kolkata_Dental。 bak

I created a backup file of my SQL Server 2005 database "Kolkata_Dental" namely Kolkata_Dental.bak manually. Now I want to format my Machine completely, after getting formatted my PC completetly SQL Server 2005 will be uninstalled from my machine. After reinstall SQL Server 2005, I want to restore and recover all my data from the Kolkata_Dental.bak file. How to do this I don't know. Please help.
Note:- The Kolkata_Dental.bak file is saved in Directory C:\\ProgramFiles\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Kolkata_Dental.bak

推荐答案

您好请参考以下链接：

http://www.techrepublic.com/blog/window-on- windows / how-do-i-restore-a-sql-server-database-to-a-new-server / 454 [ ^ ]

Hi Please refer to the following link:
http://www.techrepublic.com/blog/window-on-windows/how-do-i-restore-a-sql-server-database-to-a-new-server/454[^]

试试这个... :)

try this...:)

USE master;
ALTER DATABASE AdventureWorks2012 SET RECOVERY FULL;
GO
-- Back up the AdventureWorks2012 database to new media set (backup set 1).
BACKUP DATABASE AdventureWorks2012
  TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012FullRM.bak' 
  WITH FORMAT;
GO
--Create a routine log backup (backup set 2).
BACKUP LOG AdventureWorks2012 TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012FullRM.bak';
GO

按照以下步骤操作：



1.连接数据库引擎（sqlserver）

2.右键单击DATABASES

3.选择还原数据库

4.从您的硬盘驱动器中选择bak文件

5.&点击确定，它将开始执行

6.取决于您的备份文件大小需要时间



希望它有效。



或



试试这个



http://www.youtube.com/watch?v=BHevcPDAU7Q [ ^ ]

Follow the steps:

1. Connect DB Engine (sqlserver)
2. Right click on DATABASES
3. Select Restore Database
4. Select bak file from your Hard-drive
5. & click ok, it will start to execute
6. Depends upon your back up file size it will take time

Hope it works.

Or

try this

http://www.youtube.com/watch?v=BHevcPDAU7Q[^]

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