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'