Viewing 15 posts - 1 through 15 (of 1,155 total)
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...
September 18, 2012 at 8:43 am
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. ...
September 14, 2012 at 9:46 am
I kicked off log shipping and...
September 14, 2012 at 9:31 am
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...
September 14, 2012 at 9:29 am
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...
September 14, 2012 at 9:09 am
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...
September 14, 2012 at 8:43 am
Lynn Pettis (9/13/2012)
I actually got the additional help after reading off the post replies from here. I still don't have anything "rock solid" (to...
September 13, 2012 at 5:15 pm
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...
September 13, 2012 at 1:43 pm
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...
September 13, 2012 at 8:57 am
After seeing the screenshot, I tend to agree with Kevin.. It is likely a LSN problem here.
September 13, 2012 at 8:37 am
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....
September 13, 2012 at 8:28 am
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.
September 13, 2012 at 7:54 am
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...
September 13, 2012 at 7:49 am
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.
June 13, 2012 at 2:59 pm
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...
June 13, 2012 at 2:58 pm