Tracking Changes to a Mirror Database in SQL Server 2012

I am working on a data warehouse in the SQL Server 2012 standard. For our ETL process, I want to enable change tracking. It's easy to do, but this server is mirrored to another SQL Server 2012.

What are the implications for the mirror server? Will tracking change be enabled on the mirror server as well? Do you need to take additional steps?

+3


source to share


1 answer


Yes, it will be included in the mirror database and no, you should not have any additional configurations to set up change tracking in the mirror. You probably already know that SQL Server simply stores change data in a series of system tables (one for each table to track changes).



Regarding the implications for using this through the mirror, the added change data would also need to be propagated over the network to the mirror, and the extra space occupied by the change tables would also be considered on the mirror besides those I don't know of other implications.

+1


source







All Articles