Posted by danceli on 02/16/07 00:06

The backup file is located in server A.
how should do restore in Server B to catching backup file from serer
A??

Need I copy the backup.bak file from server A to Server B, then
schedule job to restore at server B?
How to set it automatically?


On Feb 15, 2:47 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:

> > Now I still can schedule a job for hourly full backup on server A, but
> > i have no idea how to schedule a job for hourly full restore dbs to
> > server B.
>
> ALTER DATBASE db SET SINGLE_USER WITH ROLLBACK IMMEDIATE
> RESTORE DATAHASE dh FROM DISK='locationofbackup'
> ALTER DATABASE db SET MULTI_USER
>
> Then use Enterprise Manager or Mgmt Studio to create a job, with this
> as the job step and set up a schedule.

[Back to original message]