Shinoj Ramanathan (8/9/2010)

---

I have replication setup and have separate servers for publisher, distributor and subscriber.

I need to restart my distributor. Is there a restart sequence I need to follow?

Help much...

If you decide to do the restore make sure you build in a step to update all statistics on the database. Even better would be to rebuild all the indexes.

Some more information on this can be found here. This is 2000 related but still applicable.

One example can be found here.

A good summary of locking here.

BOL is a good resource here as well.

Hope this helps.

Unfortunately snapshot replication is per database so, you would have to set it up 300 times if that is the number of databases you have to copy.

Honestly your best...

Just a couple of thoughts;

- script out all logins; Have these in place prior to moving databases

- all jobs from msdb

- any user objects (tables, procedures) in system databases;...

What kind of publication is that? You had stated no logreader agent and you were trying to create a snapshot (which should be easily recreatable). Merge?

Regardless read the documentation...

If you see nothing in the output from the following query then you can disable replication for that database.

select * from syspublications -- will check if there are any...

SQL Noob (11/19/2009)

---

i think you're safe with msdb, master i'm not 100% sure.

we went from 32 bit SQL 2005 to 64 bit a few years ago. all databases are on...

What do you see when you run select log_reuse_wait_desc,name from sys.databases for the database in question?

Check out this post and see if it helps.

If you are going with the same version of SQL then you might be ok. I will say that if you are going to use restore then you will need...

Are you seeing a log reader agent? What do you get when you run the following on the distributor?

use distribution;

go

select * from MSlogreader_agents

Do you see a log reader agent...

I only know it as we have had to work...

You have to drop the subscriptions, then go to publication properties, subscription options, top option is independent agent. Set that to false. Sadly you can't change it unless you have...

Glad you figured it out but I'm surprised that not starting the snapshot agent caused your subscription not to be created as they are not really connected. I wonder if...