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'
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'