This is very simple step.

1. Take the full backup.

2. Take the log backup.

your problem will resolve.

Dear All,

Just needs to kill the process, which is running on that database.

Then Refresh the database is will goes in off line take is online and finished.

THis will give the list of the jobs even there any step also gets failed.

select distinct b.server, a.name 'Job_Name' ,b.step_id ,

+' Jobs run_status :'+ convert(char(2), b.run_status)...