Shall I Stop the jobs when SQL in recovery Mode?

  • 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

  • one more update, the log file size is 30 GB..

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply