m.rajesh.uk (10/19/2015)
Need query to make 'is_cleanly_shutdown' to 0 in sys.databases
My guess is that if this value isn't zero, you may have a problem and should look at running DBCC CHECKDB. You should show all errors, no informational messages, and definitely don't fix anything, you want to know if there are problems first. Then ask for more help if unsure what to do. Personally, I haven't seen this before so can only guess.