Thanks Braindonor for your reply.

Will you please do a favour explaining the steps in GUI.

Thankyou....

Thank you friends for your support.

Sorry for updating this very later. The issue is resolved.

The issue was we set a scheduler to kill the idle user sessions, which is...

There is no offline databases and in maintenance plan i selected only one specific DB.

Regards

Pradeep

Thanks Bhushan for your reply.

Initially I thought same and there was really storage issue with only 50 GB in drive and the Datafile was 20GB, and Log file was 190...

Hi Gail / Shafat,

Thanks for taking your valuable time for my queries.

So have few last queries....,

?What I suppose to do if I find my DB taking a long time in...

Hi Gail

Thanks for your reply.

Understand Restoring is not same to recovery. The full story is, in the morning I restarted the DB server, after restart when I open SSMS...

Hello Gail,

Thanks a lot for your reply.

The situation is not often on restart and occur rarely. Please clarify me, if the DB is in state of Restoring, can I recover...