Yes, you are correct. I guess I am...

It's odd that the row was not caught even though logreader was turned off. Did it possibly get deleted from msrepl_commands / msrepl_transactions or did you execute an sp_repldone? If...

Dj463 (2/24/2011)

---

Everything works fine, except that whenever a value is updated at publisher the older value is not deleted at subscriber, instead i see both old and new rows at...

Do you have a solution then and / or a task outline of the steps you will need to take? If not, post what you have so far and we...

Thanks for following up and you're welcome. 😀

edwardw 90939 (2/24/2011)

---

Do I need to stop the DB instance on PROD while the renaming/swapping is taking place? Ideally there is no down time - performance slow down would be...

What are your plans for the migration after reading that document? Can you put together an outline of the steps you are going to follow and reply back with that?...

Oops - didn't read that all the way. You would also have to build in a "Use" @db_name in there as well so that the string was something like;

USE DBName;...

aroatenberry (2/24/2011)

---

I have the below script in a job, however, when it gets to a database that doesn't have the table (Errors_table), the job fails and quits. How can I...

You should review this MS LINK as it provides a great process for doing a planned move. My recommendation would be to write a script to create the file location...

Ian Scarlett (2/24/2011)

---

OMG, that makes me feel...

Grant Fritchey (2/24/2011)

---

Do not pile on to this one, please. I just thought I'd point out where I was bad. That one really yakked me off. Again, no need for...

...and you could also use with transactional replication with updatable subscriptions OR IF your data is mutually exclusive you could use peer-to-peer replication. Both of which are far less overhead...

SQL Server will still not start correct? If so, then you have to get this information from Windows.

Thanks, that is what I thought too, which is not server version which is why I was asking. 🙂