RE: Clustering Set up
From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 07/22/04
- Next message: Uttam Parui[MS]: "RE: Clustering Set up"
- Previous message: Mike Epprecht \(SQL MVP\): "Re: Clustering Set up"
- In reply to: Nitin Rana: "Clustering Set up"
- Next in thread: Uttam Parui[MS]: "RE: Clustering Set up"
- Reply: Uttam Parui[MS]: "RE: Clustering Set up"
- Reply: Nitin Rana: "RE: Clustering Set up"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 21:49:38 GMT
Nitin,
Both SQL Server 2000 Failover Clustering and SQL Server 2000 Log Shipping are disaster recovery options. Based on your requirements, you will need to decide what option best suits you. It is not uncommon to
see clients using SQL Server 2000 Failover Clustering and SQL Server 2000 Log Shipping together also. It just depends on their needs.
Here is a Microsoft Knowledge Base article that explains the various disaster recovery options
Disaster recovery options for Microsoft SQL Server
http://support.microsoft.com/?kbid=822400
After reviewing this article, you may have many qs on SQL Server 2000 Failover Clustering and SQL Server 2000 Log Shipping. Here are some links that you may find useful
Microsoft Whitepaper - SQL Server 2000 Failover Clustering >>>>>>>> Has Step By Step Instructions on installing SQL Server 2000 Failover Cluster <<<<<<<<<<
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
If you are considering Clustering then you will need to have a Certified Cluster solution.
How to locate qualified cluster solutions for Windows
http://support.microsoft.com/?id=828262
Microsoft's Cluster support policy is explained in these articles: Please read these carefully for the official support policy of
Cluster (General): http://support.microsoft.com/default.aspx?scid=kb;en-us;309395
Cluster (SQL): http://support.microsoft.com/default.aspx?scid=kb;en-us;327518
The following links will give you more information for Log Shipping
INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
http://support.microsoft.com/?kbid=314515
Whitepaper - SQL Server 2000 How To Setup Log Shipping >>>>>>>> Has Step By Step Instructions on installing SQL Server 2000 Log Shipping <<<<<<<<<<
http://www.microsoft.com/downloads/release.asp?ReleaseID=30186&area=search&ordinal=31
SQL Server 2000 Failover Clustering and Log Shipping both are very stable and fairly simple to manage (-- that will actually depend on the DBAs experience as these are advanced features). Definitely,
SQLServer 2005 will have more features as compared to SQL Server 2000. There will be more disaster recovery options -- for ex. Database Mirroring. For more information on SQL Server 2005, please visit
http://www.microsoft.com/sql/yukon/productinfo/default.asp
Here you will find lots of whitepapers and information on SQL Server 2005.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
- Next message: Uttam Parui[MS]: "RE: Clustering Set up"
- Previous message: Mike Epprecht \(SQL MVP\): "Re: Clustering Set up"
- In reply to: Nitin Rana: "Clustering Set up"
- Next in thread: Uttam Parui[MS]: "RE: Clustering Set up"
- Reply: Uttam Parui[MS]: "RE: Clustering Set up"
- Reply: Nitin Rana: "RE: Clustering Set up"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
