June 29, 2011 at 5:10 pm
I have 4 database that need to be duplicated on another server and in sync. My primary database server is SQL Server 2000 and the secondary database server is SQL Server 2008. I would like the data updated about every 15 - 30 minutes on the secondary database server. Would it be best to use Replication or Log shipping. I am pretty sure we can't use Database mirroring due to SQl Server 2000. I would appreciate anyone's expert opinion. Thanks.
June 30, 2011 at 2:31 am
manning20 (6/29/2011)
I have 4 database that need to be duplicated on another server and in sync. My primary database server is SQL Server 2000 and the secondary database server is SQL Server 2008. I would like the data updated about every 15 - 30 minutes on the secondary database server. Would it be best to use Replication or Log shipping. I am pretty sure we can't use Database mirroring due to SQl Server 2000. I would appreciate anyone's expert opinion. Thanks.
You want whole database so Go Logshipping and set the restore interval 15 or 30 minutes as you want.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 30, 2011 at 3:54 am
manning20 (6/29/2011)
I have 4 database that need to be duplicated on another server and in sync. My primary database server is SQL Server 2000 and the secondary database server is SQL Server 2008. I would like the data updated about every 15 - 30 minutes on the secondary database server. Would it be best to use Replication or Log shipping. I am pretty sure we can't use Database mirroring due to SQl Server 2000. I would appreciate anyone's expert opinion. Thanks.
What will the secondary server be used for? If users need to access it to read data, I would probably choose replication because log shipping will disconnect everyone every time it runs to apply the latest log information.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 30, 2011 at 8:59 am
Thanks for all the information. Log Shipping looks like the best solution. My users will not have access to secondary database server. secondary database server will only be used if primary database server fails.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply