SQLSERVER分离和附加数据库详解.docx

SQL SERVER 分离和附加数据库详解一. Sql 语句命令方式 RESTORE HEADERONLY FROM DISK = N'f:/' 返回包含特定备份设备上所有备份集的所有备份标头信息的结果集分离数据库 USE [master] GO EXEC master . dbo . sp_detach_db ***@dbname = N'xiantest' GO 或者 exec sp_detach_db xiantest 或 exec sp_detach_db ***@dbname = 'xiantest' 附加数据库 USE [master] GO CREATE DATABASE [xiantest] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\\MSSQL\DATA\' ), ( FILENAME = N'C:\Program Files\Microsoft SQL Server\\MSSQL\DATA\' ) FOR ATTACH GO 或 exec sp_attach_db xiantest , ***@filename1 = N'C:\Program Files\Microsoft SQL Server\\MSSQL\DATA\' , ***@filename2 = N'C:\Program Files\Microsoft SQL Server\\MSSQL\DATA\' exec sp_attach_db xiantest , N'C:\Program Files\Microsoft SQL Server\\MSSQL\DATA\' ,