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.
says the job is not running, but the
FROM msdb.dbo.sysjobs AS SJ
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...
says, deffered transactions are there.
Any help would be highly appreciated...