December 14, 2012 at 6:58 am
I have a script that is marked as being in rollback in the master database.
The wait time for this is 1492820875ms
user = Service Account,
task State = Running
Command = Killed/Rollback
waittime = 1492820875ms
wait type = MSQL_XP
The script that's rolong back is
/*
declare @Time_Start datetime
declare @Time_End DATETIME
set @Time_Start=getdate()-2
set @Time_End=getdate()
CREATE TABLE #ErrorLog (
logdate datetime
, processinfo varchar(255)
, Message varchar(500)
)
INSERT #ErrorLog (logdate, processinfo, Message)
EXEC master.dbo.xp_readerrorlog 0, 1, null, null , @Time_Start, @Time_End, N'desc';
INSERT #ErrorLog (logdate, processinfo, Message)
EXEC master.dbo.xp_readerrorlog 1, 1, null, null , @Time_Start, @Time_End, N'desc';
SELECT LogDate, Message
FROM #ErrorLog
WHERE
(Message LIKE '%error%' OR Message LIKE '%failed%')
AND processinfo NOT LIKE 'logon'
ORDER BY logdate DESC
*/
Any advise on how I can bring this to an end
Thanks in advance
December 14, 2012 at 7:05 am
Probably a xp_readerrorlog is stuck and it is waiting for that to return.
You can have a look on the server for any tasks that look like they might be associated and kill them.
What sort of server is it? Can you do a reboot?
Cursors never.
DTS - only when needed and never to control.
December 14, 2012 at 7:19 am
Wow thanks for the really quick answer.
This is a production server.
I can go for a reboot out of office hours, but need to get it cleared by onhigh ( we offer a 24/7 SLA)
I can not find any other process involved with this to kill.
edited Clean => cleared
December 16, 2012 at 11:58 pm
440692 I am just a number (12/14/2012)
I can go for a reboot out of office hours, but need to get it cleared by onhigh ( we offer a 24/7 SLA).I can not find any other process involved with this to kill.
certainly not . you should go for reboot here . wait for sometime ..often rollback proceses take time ..so be patience.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply