SQL SERVER 分离和附加数据库详解.doc

文档介绍：=N'f:/'返回包含特定备份设备上所有备份集的所有备份标头信息的结果集分离数据库USE[master]******@dbname=N'xiantest'GO或者execsp_detach_dbxiantest或execsp_detach_******@dbname='xiantest'附加数据库USE[master]GOCREATEDATABASE[xiantest]ON(FILENAME=N'C:\ProgramFiles\MicrosoftSQLServer\\MSSQL\DATA\'),(FILENAME=N'C:\ProgramFiles\MicrosoftSQLServer\\MSSQL\DATA\')FORATTACHGO或execsp_attach_dbxiantest,***@filename1=N'C:\ProgramFiles\MicrosoftSQLServer\\MSSQL\DATA\',***@filename2=N'C:\ProgramFiles\MicrosoftSQLServer\\MSSQL\DATA\'execsp_attach_dbxiantest,N'C:\ProgramFiles\MicrosoftSQLServer\\MSSQL\DATA\',N'C:\Pr