Ben,Shutdown with nowait has always worked for me as a last resort. I do issue checkpoints before and verify the identity gaps afterward, but it has very rarely given me problems over the years.
Hi Ben,As a comment, I had a similar need sometime ago and I solved it by adding a datetime column, not timestamp, on the replicate:ALTER TABLE MyTable ADD DateInserted datetime DEFAULT GETDATE() NOT NULLThe primary table (and replicate) alre...
Milton,You have to check in the licenses for the systems you deleted. The checkout and check-in process is independent of the systems page. Only after you check in the licenses will you be able to use them for other systems.
Hi,The 'replicate DDL' clause only means that the replication will not only move data operations (DML - SELECT/INSERT/DELETE/UPDATE) but also DDL, like ALTER TABLE, CREATE PROCEDURE, etc. In this way you can control whether schema changes will repl...
Hi,I don't know what is the specific hardware problem you have, but if you are able to bring online more disks in the host, you could try going the disk mirroring way, assuming it's a disk problem on the first set of disks that is preventing the back...
