Posted by danceli on 02/15/07 20:14

Actually we need replicate 3 databases from server A to server B. But
no idea why replication does not work fine.

So, my boss asked me to do hourly full backup/restore to server B,
which is kind of relication.

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.

How to make those hourly .Bak files in server A to server B, and then
do restore in server B????

BTW, thank you so much to keep helping me out!!


On Feb 15, 10:48 am, "Greg D. Moore \(Strider\)"
<mooregr_deletet...@greenms.com> wrote:
>
> Generally you have to do the initialbackup/restore yourself.
>
> I've written scripts in the past to do a fullbackup/restore but that was a
> specialized case that I replaced with a log-shipping script the first chance
> I got.
>
> I'm still unclear why you want to go the fullbackup/restore route rather
> than using log-shipping.

• Next in forum: Blobs in SQL Server
• 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]