Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Translating Logs to SQL Commands?

Author  Topic  Starsman Starting Member 1 Post Posted - 2009-07-31 : 01:42:52 Many years ago I worked as part of a team maintaining a rather large Sybase SQL replication environment. Due to certain issues, sometimes the replications would break, usually due to communication issues. When this happened, we had access to a rather useful tool, a tool that allowed us to translate transaction logs and apply them to the server that was out of zinc so we were able to bring it back to speed. Carefully handled, this allowed us to re-establish the replication without having to rebuild the remote server and not missing any data. Now, I have not been doing any replication in MSSQL, but been pondering for a long time now if there happens to exist some similar tool in the MS SQL world, something that will allow me to pick either the log file or the log backups and convert them into raw SQL commands.