如何将sqlserver2005数据库中的数据全部转移到一台新电脑上的sqlserver2005数据库中？

Question

求高手详细指导

Answer 1

1. 分离
use [master]
go
exec master.dbo.sp_detach_db @dbname = N'db_name', @skipchecks = 'false'
go
2. 附加
use [master]
go
create database [CRM_READER] on
( filename = N'D:\Data\db_name.mdf' ),
( filename = N'D:\Data\db_name_Log.ldf' )
for attach
go