October 27, 2014 at 6:53 pm
Hi All,
I have an issue with my database backup ...
so when check using sp_who2 'active'
it shows :
121SUSPENDED NT AUTHORITY\SYSTEM . DB1 BACKUP DATABASE
121RUNNABLE . .DB1 BACKUP DATABASE
121SUSPENDED . .DB1BACKUP DATABASE
that database last batch is yesterday which I believe shouldnt be that long ... it is like in hang state ....
What should i do ? the backup using third party
please kindly advise ...
Thankss
October 28, 2014 at 2:36 am
What's it waiting for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2014 at 7:37 am
You need to identify the blocking chain, which process is causing it to stop. Or, you need to identify the resource that it's waiting on in order to understand which process is holding that resource. I think that information is available through sp_who2, but that's a very old school method for retrieving information about things running on the system. You'd be better off using dynamic management views. For some good examples of queries that will help you, look to this book (it's free to download).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 29, 2014 at 11:26 pm
oh thankssss !!!
It is such a good e-book !!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply