Thank you very much John for your reply.

Steps mentioned by you will surely helpful for me to trace the issue.

Hi John,

DBCC command or utility Application gets executed only once after data sync from old database to new database.

It is a one time activity unless and until new HDD with...

Thanks Beatrix Kiddo and GilaMonster for sharing these valuable information with me.

Phil Parkin, thanks for your suggestion. Will do take care of writing a question next time.

Also, I have already...

Please elaborate on the term "TF 272".

Thanks Gianluca Sartori for your reply....

I agree for the IDENTITY value gaps during SQL Server Roles swapping.

But it had the huge difference of 10000.

Just wanted to know the exact cause...

Dear Sir,

Thanks for your reply.

As suggested, I tried these steps except M-Replication.

But the things did not executed as per expectations.

I have a DB with tables having IDENTITY column, PK, FKs,...