| Groups | Blog | Home |
sql server replication : Clustering or log shipping MS SQL 2000?
Our current SAP production environment consists of a window 2000 advanced
server and MS SQL 2000 with SAP 4.7. We would like to setup a reporting server which contains an exact copy of the production database which is up-to-date all the time during the day. I started looking into log shipping but it appears there will be some down time when the transaction logs are shipped from one sql server to the second sql server. If the second sql server takes 10 minutes to apply the transaction logs then the database is unavailable for that time period. Are there any other options? What are other Basis admins doing? Are they using Microsoft Clustering services to replicate the database? Or using SAN imaging technology to replicate the data to another server? Please advise,
Clustering won't get you there...its a high-availability solution, not
distributed processing. The requirement of near-time data pretty much says you are looking at transactional replication, or a 3rd party utility. -- Kevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm Real-world stuff I run across with SQL Server: http://kevin3nf.blogspot.com [quoted text, click to view] "Chris T." <tatroc@donotspam.gmail.com> wrote in message news:%23X3FDSCMHHA.5104@TK2MSFTNGP06.phx.gbl... > Our current SAP production environment consists of a window 2000 advanced > server and MS SQL 2000 with SAP 4.7. We would like to setup a reporting > server which contains an exact copy of the production database which is > up-to-date all the time during the day. > > > > I started looking into log shipping but it appears there will be some down > time when the transaction logs are shipped from one sql server to the > second sql server. If the second sql server takes 10 minutes to apply the > transaction logs then the database is unavailable for that time period. > Are there any other options? What are other Basis admins doing? Are they > using Microsoft Clustering services to replicate the database? Or using > SAN imaging technology to replicate the data to another server? > > > > Please advise, > >
Chris,
There are several SAN Solutions that accomplish exactly what you want. This is probably the way to go, although expensive. -- Bill [quoted text, click to view] "Chris T." <tatroc@donotspam.gmail.com> wrote in message news:%23X3FDSCMHHA.5104@TK2MSFTNGP06.phx.gbl... > Our current SAP production environment consists of a window 2000 advanced > server and MS SQL 2000 with SAP 4.7. We would like to setup a reporting > server which contains an exact copy of the production database which is > up-to-date all the time during the day. > > > > I started looking into log shipping but it appears there will be some down > time when the transaction logs are shipped from one sql server to the > second sql server. If the second sql server takes 10 minutes to apply the > transaction logs then the database is unavailable for that time period. > Are there any other options? What are other Basis admins doing? Are they > using Microsoft Clustering services to replicate the database? Or using > SAN imaging technology to replicate the data to another server? > > > > Please advise, > >
replication is ideal for this. Some SAN solutions allow you to do this sort
of a thing but they tend to be very expensive. -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Chris T." <tatroc@donotspam.gmail.com> wrote in message news:%23X3FDSCMHHA.5104@TK2MSFTNGP06.phx.gbl... > Our current SAP production environment consists of a window 2000 advanced > server and MS SQL 2000 with SAP 4.7. We would like to setup a reporting > server which contains an exact copy of the production database which is > up-to-date all the time during the day. > > > > I started looking into log shipping but it appears there will be some down > time when the transaction logs are shipped from one sql server to the > second sql server. If the second sql server takes 10 minutes to apply the > transaction logs then the database is unavailable for that time period. > Are there any other options? What are other Basis admins doing? Are they > using Microsoft Clustering services to replicate the database? Or using > SAN imaging technology to replicate the data to another server? > > > > Please advise, > >
Would Transactional Replication that is built into SQL 2000 work for this?
Or is this log shipping? http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:%23U3jCBNMHHA.448@TK2MSFTNGP04.phx.gbl... > replication is ideal for this. Some SAN solutions allow you to do this > sort of a thing but they tend to be very expensive. > > -- > Hilary Cotter > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Chris T." <tatroc@donotspam.gmail.com> wrote in message > news:%23X3FDSCMHHA.5104@TK2MSFTNGP06.phx.gbl... >> Our current SAP production environment consists of a window 2000 advanced >> server and MS SQL 2000 with SAP 4.7. We would like to setup a reporting >> server which contains an exact copy of the production database which is >> up-to-date all the time during the day. >> >> >> >> I started looking into log shipping but it appears there will be some >> down time when the transaction logs are shipped from one sql server to >> the second sql server. If the second sql server takes 10 minutes to apply >> the transaction logs then the database is unavailable for that time >> period. Are there any other options? What are other Basis admins doing? >> Are they using Microsoft Clustering services to replicate the database? >> Or using SAN imaging technology to replicate the data to another server? >> >> >> >> Please advise, >> >> > >
Transactional repl.
Log shipping is not going to give you the up to date you are looking for AND the ability to use it as a reporting server. Either one, not both -- Kevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm Real-world stuff I run across with SQL Server: http://kevin3nf.blogspot.com [quoted text, click to view] "Chris T." <tatroc@donotspam.gmail.com> wrote in message news:OH%23EOy0MHHA.1252@TK2MSFTNGP02.phx.gbl... > Would Transactional Replication that is built into SQL 2000 work for this? > Or is this log shipping? > > > http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:%23U3jCBNMHHA.448@TK2MSFTNGP04.phx.gbl... >> replication is ideal for this. Some SAN solutions allow you to do this >> sort of a thing but they tend to be very expensive. >> >> -- >> Hilary Cotter >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "Chris T." <tatroc@donotspam.gmail.com> wrote in message >> news:%23X3FDSCMHHA.5104@TK2MSFTNGP06.phx.gbl... >>> Our current SAP production environment consists of a window 2000 >>> advanced server and MS SQL 2000 with SAP 4.7. We would like to setup a >>> reporting server which contains an exact copy of the production database >>> which is up-to-date all the time during the day. >>> >>> >>> >>> I started looking into log shipping but it appears there will be some >>> down time when the transaction logs are shipped from one sql server to >>> the second sql server. If the second sql server takes 10 minutes to >>> apply the transaction logs then the database is unavailable for that >>> time period. Are there any other options? What are other Basis admins >>> doing? Are they using Microsoft Clustering services to replicate the >>> database? Or using SAN imaging technology to replicate the data to >>> another server? >>> >>> >>> >>> Please advise, >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
April 2003
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 |