Viewing 15 posts - 14,056 through 14,070 (of 49,552 total)
I think you're going to have to restore an older backup. That looks too damaged to be useful.
March 4, 2013 at 2:55 am
Typically I just let Windows balance them out via the normal scheduling. If you want to limit, rather don't use processor affinity (and please don't set maxdop to 1).
You...
March 4, 2013 at 12:55 am
Welsh Corgi (3/3/2013)
GilaMonster (3/3/2013)
Welsh Corgi (3/3/2013)
How do you check what the rollback session is waiting for?
GilaMonster
Same way you check what any session is waiting for, sys.dm_exec_requests
If you believe that...
March 4, 2013 at 12:36 am
SQL Server Express does not support SQL Agent.
By installed, do you mean the service is there?
March 3, 2013 at 3:40 pm
Check the permissions, the error is OS error 5, that is a permission problem.
Could be that in the detach the permissions on the files were changed, I have seen that....
March 3, 2013 at 3:30 pm
Welsh Corgi (3/3/2013)
How do you check what the rollback session is waiting for?
Same way you check what any session is waiting for, sys.dm_exec_requests
If you believe that Kill with the statusOnly...
March 3, 2013 at 2:16 pm
Drop the nolock. It has no effect on a table that is the target of an update, that's documented. It's also plain bad practice in most cases. Optimise the query,...
March 3, 2013 at 1:56 pm
It does work, it's the correct and only way to get the rollback status and progress.
Check what the rolling back session is waiting for.
March 3, 2013 at 1:53 pm
The SQL Server service does not have permissions on the log file or the directory it's in. Check the permissions, ensure that SQL Server service has full control over both...
March 3, 2013 at 1:30 pm
You gave the command in your first post. KILL <spid> WITH StatusOnly
March 3, 2013 at 1:08 pm
Just bear in mind that index_usage_stats only has info from the last time the database was started. If you have autoclose on or take the DB offline for any reason,...
March 3, 2013 at 11:38 am
Welsh Corgi (3/3/2013)
GilaMonster (3/3/2013)
Welsh Corgi (3/3/2013)
GilaMonster (3/3/2013)
Welsh Corgi (3/3/2013)
March 3, 2013 at 11:16 am
Welsh Corgi (3/3/2013)
GilaMonster (3/3/2013)
Welsh Corgi (3/3/2013)
March 3, 2013 at 10:54 am
Viewing 15 posts - 14,056 through 14,070 (of 49,552 total)