I agree with Steve, We had faced the same issue,

We took a full backup and setup the log shipping once again

1. Set up database mail using Surface configuration area --> Enable the Datbase mail

2. Configure the Database mail in SSM.

3. Create a static IP address .

4. Take the...

I think you should use sp_cycle_errorlog to refresh the error log without restarting the SQL Server.

I agree with you Cursor takes time. I had the same experience earlier.

Is there a way to reduce the time taken for the Insert statement in the cursor ?...

Thanks Gila. Thats a new thing I learnt today.

Index id 2 generally a non cluster index you can drop this index and recreate it.

It is not advisable to forcefully deattach and then reattach the DB. You are right data is not there in the data file. You should have a good backup plan...

You're using domain acct,and SQL Server will need to contact the domain controller to validate the acct. Check with the IT team if you have sufficient access and privileges .

>>...

I generally use this script to monitor blocking.You can create a job with this script and monitor it.

--To list all the blocking threads

SELECT s.Text, p.*

FROM sys.dm_exec_requests e with (nolock)

right...

I have not done this ..hope this link might help you

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

Check the sql agent log and job history for more information on why the maintenance plan fail. Did you changed the job owner? Some time this might be the reason....

Thanks for the link.

But this did not solve the issue. I removed the maint plan and all log shipping jobs from the primary server and manually added a new pair...

Please find the query which pulls data from the DB and push it to file.

Is there any thing You can help me out to tune it.

Thanks fopr the help !!

Thanks Gila for the prompt answer !!! Yes I have considered Replication need to work on that !!!

Thanking all of you for the valued responce. !! I have asked them to apply the patch 7 and then test it out as there are lots of CPU...