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