Hi all,

i'm using sql server 2012, last day i've used some performance query that was not run successfully.

so post stop the all active listener and application i've force quite the job. and after that go to services and try to restart the sql server, till the time on status it's showing stopping. how to fix it

You've made a mistake that stopped the service... What does the job do? Right now SQL Server tries to forward/rollback all transactions that were not committed at the time the stopping

Do nothing, just wait till it will be completed

ok thanks,

one more question.

i've a server in remote area where database size is 800GB and disk capacity is 1000gb.

currently disk capacity is showing 10 gb space free only. what to do.

no i'm sitting in corner. how to resolve. i've already taken backup of the MDF and LDF file as well.