Hi, Replication is held in week by week in our environment.
So may i know what is the steps to be follow after replication.........like DBCC CHECK IDENT...
kindly give me the full procedure to follow me.....it is really helpful for all new DBA's
Quick reply's are highly appreciated.........
asked Sep 07, 2012 at 10:02 AM in Default
Replication is a mechanism for doing, in general, one of two things, creating a copy of a database that you can then write reports against or query (snapshot isolation for one time use, and transactional replication for near real time copying), or taking data from multiple sources and ensuring that all of them match (merge replication). Once you have replication up and running, it's not like running a restore process. There is no "after" that I'm aware of at all. You will want to set up monitoring to ensure you know how your replication is behaving (assuming you're doing transactional or merge replication), along with all the standard monitoring you should already have in place.
answered Sep 07, 2012 at 10:54 AM
Grant Fritchey ♦♦