restore from command line

[Tom Corcoran]

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

Thanks, Tom.

[Simon Hayes]

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

[Tom Corcoran]

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.