Disaster recovery for SQL 2000

[gensan]

Hi,

Can anybody direct me to some documentations on how to create a disaster recovery plan for SQL 2000? The more detailed, the better.

thanks in advance.

 

[nigelrivett]

Just do a search on recovery strategies, clustering, standby, replication

What you will need to implement depends on the business requirement.

A few links

http://vyaskn.tripod.com/maintaining_standby_sql_server.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_7ypf.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replbackup_3js7.asp

http://databases.about.com/library/weekly/aa031101a.htm

http://www.sql-server-performance.com/greg_robidoux_interview.asp

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Gabriel2010]

Thanks!

Glad to be here!