sql语句数据库备份和还原

BACKUP DATABASE Qiu_DB to DISK='D:\mydb.bak'



RESTORE DATABASE Qiu_DB
FROM DISK = 'd:\mydb.bak'
with replace,
MOVE 'Qiu_DB' TO 'D:\Qiu_DB.mdf',
MOVE 'Qiu_DB_log' TO 'D:\Qiu_DB.ldf'