After Replication???????

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.........

more ▼

asked Sep 07, 2012 at 10:02 AM in Default

avatar image

2.5k 72 76 83

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Sep 07, 2012 at 10:54 AM

avatar image

Grant Fritchey ♦♦
137k 20 46 81

Hi Grant Frichey......thank u for your answer.........But my question is what are the steps to be follow in source database after replication.......that is if any issues in replication can we check the identity in the table and is it should be reset identity column in table? ........

Sep 07, 2012 at 11:05 AM askmlx121

I don't understand. Which type of replication are we talking about. For snapshot, there's nothing to do. For transactional replication, you need to monitor the replication process because of the distribution server goes offline, you can fill the log. For merge... cross your fingers & hope everything runs. But there isn't an "after" that I've ever done. So you need to help understand what problem you're trying to solve or prevent.

Sep 07, 2012 at 11:08 AM Grant Fritchey ♦♦

ok thank you........Grant Fritchey........

Sep 07, 2012 at 11:21 AM askmlx121
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 07, 2012 at 10:02 AM

Seen: 630 times

Last Updated: Sep 07, 2012 at 11:24 AM

Copyright 2018 Redgate Software. Privacy Policy