Thanks Gail for the help.
Yes, I have overlooked the client connection where it was originating.
Thanks again.

Thanks HanShi and Gail for reply.

I agree with you both, recently I had performance issue for the restored databases on QA (with same SQL edition and version ) and...

Looks like some bug or at most I can think of storage related issues which I am working with my team as I don't see any error in SQL logs...

Ron- Thanks for the reply.

How do you suggest to cross check 3000 excel records with more than 10 million records with sql db table.

My logic goes with sql script.

1. ...

Did you check below link.....

http://msdn.microsoft.com/en-us/library/bb520958.aspx

I beleive you should first go with SP2 then upgrade your server with SP3 additionally before applying SP3 in production test it properly.

The query cost was 100% on both servers and other attributes were also common.

Thanks for response,

I've checked the location of msdb database it seems ok. Is there any other way without restoration of msdb database.

Regards,

austin

Thanks to all.....

Thanks for the links

Are u using any monitor server for logshipping...

Hi Nisha,

I have around 7 yrs of exp as a DBA earlier I was developer for 2 years then I read some books about basic administration then Advance concepts. The...

Nice script Jeff, thanks

Thanks George...

Austin

Thanks Vivien ,

But can I use Bulk logged recovery model in log shipping.....

Austin