Clustering Set up

I am thining about either setting up Cluseting on SQL
Server or follow log shipping. Does anyone has any
recommendation as to which one should be chosen? Also,
can someone direct me to a proper location where there is
step by step instruction on how to set up Clustering/ Log
Shipping.
Also, Is it easy to manager Clustering or LS or it's a
nightmare.
Does anyone know if it is easier to manager Clustering/ LS
in SQL 2005. I may wait for another few months if it is
more stable and easier to manage in the new release.
Any help will be highly appreciated.
-Nitin
Books On Line has a lot of information on Clustering and Log shipping setup.
What are you trying to achieve with clustering / log shipping?
High availability? Reporting Server?
As soon as you go clustering, you need expensive hardware and shared storage
(SAN), Enterprise Editions of the OS and SQL.
Log shipping is easier as you can use existing hardware that you may have.
Yukon does make it easier to setup and manage, but you still need to know
what you are doing if you cluster as SQL uses the OS's clustering services
to run on.
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nitin Rana" <Nitin_Rana@.Ibi.com> wrote in message
news:23d701c47022$776b82b0$a601280a@.phx.gbl...
> I am thining about either setting up Cluseting on SQL
> Server or follow log shipping. Does anyone has any
> recommendation as to which one should be chosen? Also,
> can someone direct me to a proper location where there is
> step by step instruction on how to set up Clustering/ Log
> Shipping.
> Also, Is it easy to manager Clustering or LS or it's a
> nightmare.
> Does anyone know if it is easier to manager Clustering/ LS
> in SQL 2005. I may wait for another few months if it is
> more stable and easier to manage in the new release.
> Any help will be highly appreciated.
> -Nitin
|||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/pro.../failclus.mspx
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/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...b;en-us;309395
Cluster (SQL): http://support.microsoft.com/default...b;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/r...rch&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/p...fo/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
|||For Top 30 Features of SQL Server "Yukon", visit
http://www.microsoft.com/sql/yukon/p...30features.asp
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
|||Uttam,
This information really looks like it contains lots of
useful information. I will go over this information and
would like to set it up. Thanks and your help is really
appreciated.
-Nitin
>--Original Message--
>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/pro.../sql/2000/main
tain/failclus.mspx
>Microsoft SQL Server 2000 High Availability Series
>http://www.microsoft.com/technet/pro.../sql/2000/depl
oy/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[vbcol=seagreen]
>http://support.microsoft.com/?kbid=314515
>Whitepaper - SQL Server 2000 How To Setup Log Shipping
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/p...fo/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
>
>.
>
|||You can also check out the book SQL Server 2000 High
Availability from MS Press as well ... it goes into more
depth and has Windows Server 2003 content.