August 20, 2010 at 3:24 pm
We have a production sql server 2000 with a db (about 90G) running on NT.
Some users are running queries directly on the server.
We need to make a copy from that db (on the smae or another machine), probably a replication, only for users to run queries. What is the best solution?
Thanks,
September 2, 2010 at 9:41 am
If you want the latest data, the best would be to use transactional replication to another server where the users can run their reports. If you do not mind if the data is a bit old, you could set up a log shipping process. This could act as your DR plan as well.
-Roy
September 3, 2010 at 8:23 am
Thanks Roy, log shipping is better in my case since replication puts more load to the server.
September 4, 2010 at 4:32 pm
Are any of the queries these users will run going to be expected to modify the data in anyway?
Joie Andrew
"Since 1982"
September 4, 2010 at 5:02 pm
No, Just heavy SELECT queries!
September 5, 2010 at 4:12 pm
Yeah, then either log shipping or transactional replication. You can setup transactional replication not to have immediate updates to reduce some of the load on the box. If you have multiple machines available with good connectivity though, then I would setup two with transactional rep with immediate updates.
Joie Andrew
"Since 1982"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply