August 9, 2010 at 9:35 pm
How do I set triggers to record all changes to all databases to a file, so I can execute them on a remote database(for daily backups of changes).
For example every time any change is made in the database the query that affected the database is recorded in a file to be mass executed.
My version is SQL\MSDE.
Thanks
August 9, 2010 at 10:06 pm
This would be cumbersome in T-SQL. You'd be better off running SQL Trace and capturing all changes that way, replaying them against another copy of the database.
August 9, 2010 at 10:29 pm
How would I do this, forgive me I am a bit of a newb in this area.
August 10, 2010 at 3:15 am
Continues here - http://www.sqlservercentral.com/Forums/Topic966360-1292-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply