Posted by Greg D. Moore \(Strider\) on 02/16/07 04:10

<danceli@gmail.com> wrote in message
news:1171584368.655858.325050@p10g2000cwp.googlegroups.com...
> The backup file is located in server A.
> how should do restore in Server B to catching backup file from serer
> A??
>

Use UNCs to refer to the location of the backup.

I'm assuming you're NOT backing up the file to the same local disk on
ServerA.


> 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]