February 27, 2002 at 2:27 pm
[SQL Server 2000 Enterprise Edition on Windows 2000 Advanced Server]
We want to copy the data from our Production SQL Server to another SQL Server to run reports on it.
What method it easiest for this ?
(Replication, Log Shipping...)
--> The DB is 3GB at its peak.
February 27, 2002 at 2:45 pm
Easiest? Backup/Restore.
Need more real time, then replication may be best.
Steve Jones
February 27, 2002 at 3:22 pm
real time of course.
Log shipping or replication ???
February 27, 2002 at 3:31 pm
I'd vote replication,though I think Im in the minority.
Andy
February 27, 2002 at 4:28 pm
I'd vote log shipping, but honestly don't like either one.
Let me clarify with Replication is more mature and probably more stable. If you have an issue, it might be a bear to untangle.
Log shipping is simpler, but less mature and people have found bugs. I'd implement my own log shipping if I had to.
Steve Jones
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply