It is a bug on version. When you upgrade your SP, it will go away.

From the server where you are restoring, are you able to get to the share where you have the back up? Do you see high IO waits on the VS?...

Long time since I have been here.... Did I miss anything other than Spanish Inquisition?

What SP level are you in? This was a bug when they introduced CDC. But i has been resolved already.

Roust_m (3/26/2012)

Where should I use Snapshot isolation? The SPs...

The only option I can think of that can help is Snapshot Isolation. I cant think of anything else.

The MSDN website has a step by step procedure to trouble shoot this. Take a look at this URL.

As long as you have tested the application that uses the DB and also if you have run the Upgrade advisor and did not find any issue, why would you...

The domain account that you are planning to use, does it have "Log on as Service" permission?

I have not heard of Security issues due to backward compatibility. There could be other issues. Make sure that you run the Upgrade advisor for the DB's resolve all the...

After two weeks I am back. Actually I did not go anywhere but the work kept me busy.

So what is the topic now? Anything interesting happened during the last...

What rights have you given for the Publisher and the distributor users you are using?

Did you try sp_removedbreplication '<Database name>'? This has to be run on the pubisher and subscriber.

Just a shot in the dark, Did you try running the SSMS in administrator mode. Right click on SSMS and use the Run as adminstrator option.

Thanks Jack for the excellent advice. The next two week is going to be challenging. My CTO is off the island. So everything has to be taken care off. I...