|
|
You're in the
sql server clustering
group:Clustering Set up
sql server clustering:
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.
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 [quoted text, click to view] >-----Original Message----- 2000 Log Shipping are disaster recovery options. Based on >Nitin, > >Both SQL Server 2000 Failover Clustering and SQL Server your requirements, you will need to decide what option best suits you. It is not uncommon to [quoted text, click to view] >see clients using SQL Server 2000 Failover Clustering and SQL Server 2000 Log Shipping together also. It just depends on their needs. [quoted text, click to view] > Server 2000 Failover Clustering and SQL Server 2000 Log >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 Shipping. Here are some links that you may find useful [quoted text, click to view] > Clustering >>>>>>>> Has Step By Step Instructions on >Microsoft Whitepaper - SQL Server 2000 Failover installing SQL Server 2000 Failover Cluster <<<<<<<<<< [quoted text, click to view] >http://www.microsoft.com/technet/prodtechnol/sql/2000/main articles: Please read these carefully for the official tain/failclus.mspx > >Microsoft SQL Server 2000 High Availability Series >http://www.microsoft.com/technet/prodtechnol/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 support policy of [quoted text, click to view] >Cluster (General): http://support.microsoft.com/default.aspx?scid=kb;en-us;309395 [quoted text, click to view] >Cluster (SQL): http://support.microsoft.com/default.aspx? are very stable and fairly simple to manage (-- that will 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 actually depend on the DBAs experience as these are advanced features). Definitely, [quoted text, click to view] >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 [quoted text, click to view] > Technology Protection Program and to order your FREE >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 Security Tool Kit, please visit http://www.microsoft.com/security. [quoted text, click to view] > access update their Microsoft software to better protect >Microsoft highly recommends that users with Internet against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites: [quoted text, click to view]
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
For Top 30 Features of SQL Server "Yukon", visit
http://www.microsoft.com/sql/yukon/productinfo/top30features.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
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/ [quoted text, click to view] "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
You can also check out the book SQL Server 2000 High
Availability from MS Press as well ... it goes into more
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |