restore from command line

I want to restore a backup copy of a database from the command line. Can
this be done?

Thanks, Tom.

You can use osql.exe - something like this:

osql.exe -S MyServer -E -Q"restore database MyDB from ..."

See osql and RESTORE in Books Online.

Simon

Simon Hayes  wrote:
> You can use osql.exe - something like this:
>
> osql.exe -S MyServer -E -Q"restore database MyDB from ..."
>
> See osql and RESTORE in Books Online.
>
> Simon


Thanks for that.

osql.exe -S MyServer -E -Q"RESTORE DATABASE MyDB FROM disk = '\\MyServer
\my Backups\the backup'"

Works great.

Tom.