:: :: SQL Server 2005で、指定した複数DBをリストアするバッチ :: :: [version] :: 2008.12.09 ASN定村 初版作成 :: 2008.12.10 ASN定村 ファイル名に時刻を記録するよう変更 :: 2008.12.19 ASN定村 ファイル名に時刻を記録しないよう変更 @echo off set DBs=Common IGuide LOKMSTB2B LOKMSTB2C LOKMSTIDX LOKMSTSRH LOKSMRB2B LOKSUM LOKTRN Shop TOURINT_TVG4 set DBMS=172.105.17.15 set AUTH=-U dbteam -P dbteam ::set AUTH=-E set DIR=D:\Backup_Area\DB FOR %%A IN (%DBs%) DO ( xcopy /Y /R %%A.bak \\172.105.17.15\d$\Backup_Area\DB\ sqlcmd -S %DBMS% %AUTH% -Q "RESTORE DATABASE %%A from disk='%DIR%\%%A.bak' WITH REPLACE, KEEP_REPLICATION" ) set DBs=WISH LOKHOSTB2B set DBMS=172.105.17.15\third set AUTH=-U dbteam -P dbteam ::set AUTH=-E set DIR=D:\Backup_Area\DB FOR %%A IN (%DBs%) DO ( xcopy /Y /R %%A.bak \\172.105.17.15\d$\Backup_Area\DB\ sqlcmd -S %DBMS% %AUTH% -Q "RESTORE DATABASE %%A from disk='%DIR%\%%A.bak' WITH REPLACE, KEEP_REPLICATION" ) pause