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.

• Next in forum: Re: Replace Multiple Spaces with One Space?
• Prev in forum: Re: Backup and restore database hourly: how to implement it?
• Thread view: Re: Backup and restore database hourly: how to implement it?

[Reply to this message]