Clustering Set up

#1

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

#2

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 (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Nitin Rana" <Nitin_Rana (AT) Ibi (DOT) com> wrote

Quote:

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

#3

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

Quote:

-----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

Quote:

see clients using SQL Server 2000 Failover Clustering and
SQL Server 2000 Log Shipping together also. It just

depends on their needs.

Quote:

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

Quote:

Microsoft Whitepaper - SQL Server 2000 Failover
Clustering >>>>>>>> Has Step By Step Instructions on

installing SQL Server 2000 Failover Cluster <<<<<<<<<<

Quote:

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

Quote:

Cluster (General):
http://support.microsoft.com/default.aspx?scid=kb;en-

us;309395

Quote:

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,

Quote:

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

Quote:

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.

Quote:

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:

Quote:

http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

.

#4

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Clustering Set up

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Clustering Set up - 07-22-2004 , 02:31 PM

Re: Clustering Set up - 07-22-2004 , 04:36 PM

RE: Clustering Set up - 07-22-2004 , 05:14 PM

RE: Clustering Set up - 07-27-2004 , 01:06 PM