示例
下面的示例将 pubs 中的两个文件附加到当前服务器。
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:/Program Files/Microsoft SQL Server/MSSQL/Data/pubs.mdf',
@filename2 = N'c:/Program Files/Microsoft SQL Server/MSSQL/Data/pubs_log.ldf'
备份SQL:
BACKUP DATABASE Northwind TO DISK = 'C:/Northwind.bak'
还原SQL:
RESTORE FILELISTONLY FROM DISK = 'C:/Northwind.bak'