What version of SQL Backup are you using? I found a forum post that said that SQL Backup would hang with a msql_xp wait type. I believe this...

Yes sir. Next week it is....

One thing to ponder before we going into the weekend is perhaps you have resource contention at multiple levels that is causing issues. ...

matt.newman (9/14/2012)

---

One of the log shipping jobs that is a very small and nearly static database seems to be at the root of this, somehow.

I kicked off log shipping and...

The log shipping is not likely to be causing your SQL Server problem, as it will use a native driver; however, it is possible that the linked server to MySQL...

In cases where I have seen this happen, while on the DB Server in question, my RDP session would become unresponsive and then a box was saying it was trying...

One of the things you can do to check whether or not a networking issue is at hand, is to actually RDP to the server itself.. If you have a...

Lynn Pettis (9/13/2012)

---

matt.newman (9/13/2012)

---

Dah Blame Area (until proven otherwise)?

I actually got the additional help after reading off the post replies from here. I still don't have anything "rock solid" (to...

I have seen issues like this happen when there are problems at the switch level that cause brief but annoying flapping. In the case I am speaking of, someone...

You can run

restore headeronly against your backup files and look at the databasebackuplsn and then you can walkthrough the log backup lsn chain from here and make sure they...

After seeing the screenshot, I tend to agree with Kevin.. It is likely a LSN problem here.

Make sure the SQL Server accounts (DB Engine & Agent) running the secondary instance have permission to the directory where the backups are stored and permissions to the share itself....

Another thought is maybe the restore job is looking in the wrong directory, and the job doesn't find any backups that need restoring, so it reports success.

Even though the job reports success, I would still look at the agent history and in the second step from the top. There should be some detail about why...

With that said, don't go and add every column to every index... This is something you have to watch and take action where appropriate.

A key lookup occurs when the optimizer has to go to the clustered index for every column not present in the index. The number of seeks is equal to...