摘要:
--备份数据库BACKUP DATABASE test to disk = 'D:\test.bak' --完整备份go--数据库还原--1、附加数据库create database hotelbook_Dataon primary(filename='D:\shujuku\hotelbook_Data.mdf')for attach--2、还原用BACKUP备份的数据库RESTORE DATABASE TESTDBFROM DISK = 'D:\test.bak'WITH MOVE 'TEST' TO 'D:\SQL\t 阅读全文