I am facing a small issue. I would appreciate everyone's help here.

Thanks Tom. I tried to do that and I guess I succeeded.

Road Rage... No wonder Road rage is common now a days

Thanks ALZDBA. I will have to plan for the agent shutdown and enabling it. I think we can live with it this weekend. (We are very busy during weekend)

Thanks...

We do not use DB mail. I will try to enable Service broker on MSDB. The question I have is should we enable Service broker in the Master as well.

Thanks Brandie. I will have to arrange for a shutdown time. We are 24/7 shop and it is always busy. We always have around 4000 batch request per second.

I have trouble in our paradise. Could someone help me confirm if what I plan to do will work?

Maybe put that as...

I think everyone who has followed the story of the miners felt very touched by this. It actually brings a tear of joy when you see the video of the...

I thought you were using SQL 2008 since the question is in the SQL 2008 forum. The normal back ups does not compress the data. Therefore RAR file can compress...

CDC uses the transactional replication log reader agent to harvest changes from the transaction log. Could this be the reason why you are seeing this problem? I have never implemented...

Take a compressed backup. It will almost be the same size as that of the .RAR file. When you take a normal back up, the data is not compressed. The...

For transactional replication, make sure that all table that you want to replicate have a PK.

You can initialize the subscriber with Snapshots or from Back up. Try to set the...

Did you do a compressed back up or a normal back up?

Gail, I thought Gail were working for yourself. I did not know that you were working for some company.