Using osql and trusted connection for SQL Server 2000. @echo off if {%2}=={} ( call :Usage goto :EOF)net stop mssqlservernet start mssqlserverosql -E -d master -Q “restore database %1 from disk=’%2′ with replace” goto :EOF::Subroutine area :Usage @echo Syntax: call restoredb.bat DatabaseNameFullDatabaseBackupPath goto :EOF
Posts