备份:
backup database OfficeDB to disk = 'E:/2010工作目录/DB/OfficeWebTest1-99-0402.bak'
还原:
RESTORE DATABASE OfficeDB
FROM DISK= 'E:/2010工作目录/DB/OfficeWebTest1-99-0402.bak'
WITH MOVE 'HFOA_DATA' TO 'D:/Program Files/Microsoft SQL Server/MSSQL/Data/OfficeDB.MDF',
MOVE 'HFOA_LOG' TO 'D:/Program Files/Microsoft SQL Server/MSSQL/Data/OfficeDB.LDF'