Report Server.

Hi,
We are using a live database, which is growing rapidly.Keeping performance
at acceptable level is critical.
We are considering a second server(mirror of the live data - up to 30
minutes offset is acceptable) - for running costly queries,mainly for
reports.
What are the options we could use to maintain a mirror ?
Any suggestions will be greatly appreciated. The live database is a SQL
Server 2000 Enterprise SP 3a (Clustered) on Windows 2003 Server Enterprise
SP1 (Cluster).
Regards.
Sezgin
Transaction Replication for SQL Server 2000 is probably the best option. Log
shipping or backup/restore don't tend to work well as the database on the
'reporting' server is unavailable when the restore takes place.
Nick Grattan
www.nickgrattan.net
"Sezgin Rafet" wrote:

> Hi,
> We are using a live database, which is growing rapidly.Keeping performance
> at acceptable level is critical.
> We are considering a second server(mirror of the live data - up to 30
> minutes offset is acceptable) - for running costly queries,mainly for
> reports.
> What are the options we could use to maintain a mirror ?
> Any suggestions will be greatly appreciated. The live database is a SQL
> Server 2000 Enterprise SP 3a (Clustered) on Windows 2003 Server Enterprise
> SP1 (Cluster).
> Regards.
> Sezgin
>
>
|||Thanks for the reply. Is there any 3rd party software producing the effect
of Transactional Replication, being easy to set up and maintain ?
Any links to good step by step guides for Transactional Replication will
also be appreciated. I suspect it's a difficult job to set up and maintain
Transactional Replication, but I may give it a try.
Regards.
Sezgin
"Nick Grattan" <NickGrattan@.discussions.microsoft.com> wrote in message
news:21B5A6A2-67A7-4EF1-9C19-E631531D8194@.microsoft.com...[vbcol=seagreen]
> Transaction Replication for SQL Server 2000 is probably the best option.
> Log
> shipping or backup/restore don't tend to work well as the database on the
> 'reporting' server is unavailable when the restore takes place.
>
> --
> Nick Grattan
> www.nickgrattan.net
>
> "Sezgin Rafet" wrote: