Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Shall I Stop the jobs when SQL in recovery Mode? Expand / Collapse
Author
Message
Posted Thursday, May 16, 2013 12:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:40 AM
Points: 324, Visits: 946
hi,

i ran a job which is updating almost 300 GB database.

now i see that the Db is in recovery mode. I know that I should wait till it recovers.

EXEC dbo.sp_stop_job
N'jobname'

says the job is not running, but the
SELECT *
FROM msdb.dbo.sysjobs AS SJ
INNER JOIN
msdb.dbo.sysjobactivity AS SJA
ON SJ.job_id = SJA.job_id
WHERE SJ.enabled = 1
AND NOT SJA.start_execution_date IS NULL
AND SJA.stop_execution_date IS NULL


gives two records...

DBCC CHECKDB


says, deffered transactions are there.

Any help would be highly appreciated...
Thanks,
Regards,
Ami
Post #1453336
Posted Thursday, May 16, 2013 1:01 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:40 AM
Points: 324, Visits: 946
one more update, the log file size is 30 GB..
Post #1453341
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse