General discussion


SQL Server 2000 data replication issue

By bhendrix ·
We currently have a production installation of SQL Server 2000 Enterprise Edition that has a 40 gig database that is hit heavily. I am setting up another installation of SQL 2000 to host a read only copy of the production database to strictly run reports. The data will need to be updated once a day at night.

I am looking at the following options.

-Snapshot Replication. This will be done overnight, but I am concerned with how a snapshot will handle a 40 gig DB and the time it will take.

-Transaction Replication. Will need to do the initial snapshot, but then only update changes via the TLogs at night? Not sure if you can schedule how often the Tlogs are referenced to change the read only db.

-DTS Pakcage. Schedule a DTS package to copy the production DB to the Report Server every night. Again, with 40 gig DB, this is going to take awhile.

Does anyone have any thoughts on what method would be better? Thanks.

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Back to Networks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums