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