备份:
将C:/Program Files/Microsoft SQL Server/MSSQL/Data中的
XXX.MDF文件和XXX_log.LDF文件备份就OK,其中XXX为数据库名字
恢复
将XXX.MDF文件和XXX_log.LDF文件拷贝到SQLSERVER的C:/Program Files/Microsoft SQL Server/MSSQL/Data目录中,
运行:
EXEC sp_attach_db @dbname = N'XXX',
@filename1 = N'C:/Program Files/Microsoft SQL Server/MSSQL/Data/XXX.MDF',
@filename2 = N'C:/Program Files/Microsoft SQL Server/MSSQL/Data/XXX_log.LDF'