SQL Server 2008如何复制数据库

SQL Server 2008如何复制数据库：方法一：使用Microsoft SQL Server Management Studio中的Copy Database Wizard来辅助完成。（很容易失败）方法二：采取Backup/Restore的方式（推荐）a.备份数据库到磁盘BACKUP DATABASE Source_Database
TO DISK = "D:BackupSource_Database.bak"
WITH FORMAT;b.查看备份文件的逻辑文件RESTORE FILELISTONLY
FROM DISK = "D:BackupSource_Database.bak";c.创建目标数据库CREATE DATABASE Target_Database;d.从磁盘复制数据库/*
利用bak恢复数据库，强制还原（REPLACE）
STATS = 10 每完成10%显示一条记录
Source_Database和Source_Database_log是上面D:BackupSource_Database.bak里的逻辑文件
*/
RESTORE DATABASE Target_Database
FROM DISK="D:BackupSource_Database.bak"
WITH
MOVE "Source_Database" TO "C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATATarget_Database.mdf",
MOVE "Source_Database_log" TO "C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLDATATarget_Database_log.ldf",
STATS = 10,REPLACE本文永久更新链接地址