November 3, 2011 at 10:38 am
I have a situation where I need to have a copy of a database in another server and keep it updated via: 1) log shipping, 2) mirroring, 3) data replication. My problem comes in that: 1) log shipping and mirroring are really out of the question because the primary server is in sql server 2005 and my secondary server is in 2008 and you can't restore the copy of the backup in a stand-by state, 2) the database sitting on the secondary server will have triggers that need to fire when an event occurs and triggers don't work when your using logshipping or mirroring because the database is in a read only mode.
Would you suggest using transactional replication because you can have a trigger on the database on the secondary server.
Your suggestions are greatly appreciated.
November 3, 2011 at 11:47 am
Thanks for the link. If I had a choice I would rather use log shipping but, because of the triggers and the fact that I'm trying to log ship from a sql server 2005 server to a sql server 2008 server I can't leave the database in a Read-Only Stand-by state because of incompatabilities.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply