Posted by Daniel.Peaper@gmail.com on 02/21/07 06:05

Hi Everyone,

I'm working on a site that is running MS SQL 2000. They perform
regular backups of databases and log files and in the event of a
disaster they have a second backup server.

At present they regularly copy the backup up files from the production
server to the standby server. The plan, in the event of a disaster, is
to restore these backups onto the standby server and change the dns
records so that client machines will point to the standby server.

Is there a better way?

Thanks for any advice,
Danny

• Next in forum: Re: What is the best availability and backup solution?
• Prev in forum: Re: Storing variable values whilst using cursors
• Thread view: What is the best availability and backup solution?

[Reply to this message]