sqlcmdでMSSQL復元エラー

Question

前提・実現したいこと

DelPro.bakでデータベースを復元するのはrestore.batで自動的に実現したいです。

発生している問題・エラーメッセージ

18:03:02.70 
Msg 1834, Level 16, State 1, Server DESKTOP-QRFRQ8A\DELPRO, Line 1
The file 'c:\Program Files\Microsoft SQL Server\MSSQL11.DELPRO\MSSQL\DATA\DDMVMS.mdf' cannot be overwritten.  It is being used by database 'DDMVMS'.
Msg 3156, Level 16, State 4, Server DESKTOP-QRFRQ8A\DELPRO, Line 1
File 'DDMVMS' cannot be restored to 'c:\Program Files\Microsoft SQL Server\MSSQL11.DELPRO\MSSQL\DATA\DDMVMS.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 1834, Level 16, State 1, Server DESKTOP-QRFRQ8A\DELPRO, Line 1
The file 'c:\Program Files\Microsoft SQL Server\MSSQL11.DELPRO\MSSQL\DATA\DDMVMS_log.ldf' cannot be overwritten.  It is being used by database 'DDMVMS'.
Msg 3156, Level 16, State 4, Server DESKTOP-QRFRQ8A\DELPRO, Line 1
File 'DDMVMS_log' cannot be restored to 'c:\Program Files\Microsoft SQL Server\MSSQL11.DELPRO\MSSQL\DATA\DDMVMS_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Server DESKTOP-QRFRQ8A\DELPRO, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Server DESKTOP-QRFRQ8A\DELPRO, Line 1
RESTORE DATABASE is terminating abnormally.
18:03:02.84 

該当のソースコード

echo 開始：%date% %time% >> C:\DelPro\Backup\restore.log
sqlcmd -S DESKTOP-QRFRQ8A\DELPRO -Q "RESTORE DATABASE db_Sales FROM DISK = N'C:\DelPro\Backup\ArimuraFarm_DailyDelPro5.2_20180815T011006_V_HN_FW_TAI_OPT_BCS.bak\DelPro.bak' WITH FILE = 1, REPLACE" >> C:\DelPro\Backup\restore.log
echo 完了：%date% %time% >> C:\DelPro\Backup\restore.log

試したこと

データベースはすでに存在している可能性があるので、「cannot be overwritten」エラーが出ています。
下記で実行してみましたが、エラーが変わらないです。

sqlcmd -S DESKTOP-QRFRQ8A\DELPRO -Q "RESTORE DATABASE db_Sales FROM DISK = N'C:\DelPro\Backup\ArimuraFarm_DailyDelPro5.2_20180815T011006_V_HN_FW_TAI_OPT_BCS.bak\DelPro.bak' WITH FILE = 1,MOVE N'DDMVMS' TO N'c:\Program Files\Microsoft SQL Server\MSSQL11.DELPRO\MSSQL\DATA\DDMVMS.mdf',  MOVE N'DDMVMS_log' TO N'c:\Program Files\Microsoft SQL Server\MSSQL11.DELPRO\MSSQL\DATA\DDMVMS_log.ldf', REPLACE" >> C:\DelPro\Backup\restore.log

Answer 1

解決しました。
データベースすでに存在すれば、事前に削除しないといけません。
echo 開始：%date% %time% >> C:\DelPro\Backup\restore.log
sqlcmd -S DESKTOP-QRFRQ8A\DELPRO -Q "ALTER DATABASE DDMVMS SET SINGLE_USER WITH ROLLBACK IMMEDIATE" >> C:\DelPro\Backup\restore.log
sqlcmd -S DESKTOP-QRFRQ8A\DELPRO -Q "drop database DDMVMS" >> C:\DelPro\Backup\restore.log
sqlcmd -S DESKTOP-QRFRQ8A\DELPRO -Q "RESTORE DATABASE db_Sales FROM DISK = N'C:\DelPro\Backup\ArimuraFarm_DailyDelPro5.2_20180815T011006_V_HN_FW_TAI_OPT_BCS.bak\DelPro.bak' WITH FILE = 1,MOVE N'DDMVMS' TO N'c:\Program Files\Microsoft SQL Server\MSSQL11.DELPRO\MSSQL\DATA\DDMVMS.mdf', MOVE N'DDMVMS_log' TO N'c:\Program Files\Microsoft SQL Server\MSSQL11.DELPRO\MSSQL\DATA\DDMVMS_log.ldf', REPLACE" >> C:\DelPro\Backup\restore.log
echo 完了：%date% %time% >> C:\DelPro\Backup\restore.log