Database Discussion - SQL Server 2K Disaster Recovery

Print Page | Close Window

SQL Server 2K Disaster Recovery

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12232
Printed Date: 30 March 2026 at 12:17pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server 2K Disaster Recovery

Posted By: Gary
Subject: SQL Server 2K Disaster Recovery
Date Posted: 19 October 2004 at 10:18am

What is the best way to provide a DR plan for SQL databases?
A simple backup of a single database would not be sufficient as there are other components to consider such as user accounts within SQL and more importantly (to me) are the DTS packages which are not contained within the database itself.

Any comments, ideas, or links would be much appreciated.

Thanks

Gary

Replies:

Posted By: michael
Date Posted: 19 October 2004 at 10:33am

The best frontline defense would be a mirror server using Clustering, that way you have an exact image of the server still functional if 1 fails, then you can just rebuild the cluster. If you do not have 2 or more server available you can actually create a backup instance on the same machine and copy all objects over there, this will drag on your servers performance though. Using some good software like Veritas Backup Exec SQL Agent will let you backup everything you need to rebuild the server including the master database which can become somewhat tricky with standard sql backups.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker