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]

Re: restore from command line

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]

Re: restore from command line

Simon Hayes wrote:[color=blue]
> 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[/color]


Thanks for that.

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

Works great.

Tom.