Can you post the exact Error Message?

Is it Transactional replication what we are talking about?

What tool/method are you using to create the subscription?

OOps! I didn't realized this was and old post.

I even have a script to figure out which log to replay to get to any point in time!

You should practice it every once in a while though.

And in addition...

can't believe this "thing" is still alive

you should check the server for blocking issues and review SQL Server Error log for any anomally

I am also curious why an App would put a DB in single_user mode!

the IP address is your clue to figure out the origin!

jude (2/26/2009)

---

Thanx for the answer....

What if I restore the db now, setup the publications, script them and then after the next restore run the publication scripts

Can I use existing subscriptions...

Normally ASYNC_IO_WAIT is an indication of client-side slowness.

NicholeRS (2/26/2009)

---

Hey, All, Question: I'm running Transactional Replication and have my snapshot agent running every hour and my log reader & distribution agents running every 5 minutes. I've...

I know this won't help a lot but at least you know that you are not alone:

http://www.sqlservercentral.com/Forums/Topic429499-291-1.aspx

jude (2/26/2009)

---

I restored a replicating db from a Sql 2000 server to a Sql 2005 server.

When it's time to take this db to production, I will restore the existing db...

cheeky1981 (2/26/2009)

---

Hi,

Any advice would be appreciated as I'm a newbie to replication. Unfortunately I've come across what seems to be a really nasty issue when a column is added to...

It looks like there are no publications actually defined.

please verify the results with sp_helppublication

Jeffrey Williams (2/25/2009)

---

No, the only time it is not valid is when you use...