Restoredb.bat

Using osql and trusted connection for SQL Server 2000.

@echo off

if {%2}=={} (
    call :Usage
    goto :EOF
)
net stop mssqlserver
net start mssqlserver
osql -E -d master -Q "restore database 
%1 from disk='%2' with replace"

goto :EOF
::Subroutine area 

:Usage
    @echo Syntax: call restoredb.bat DatabaseName 
FullDatabaseBackupPath

goto :EOF