Post reply

Need Query

  • October 19, 2015 at 4:31 pm

    #304374

    Need query to make 'is_cleanly_shutdown' to 0 in sys.databases

  • October 19, 2015 at 6:19 pm

    #1834230

    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.

  • October 19, 2015 at 6:35 pm

    #1834232

    DBCC check db came clear for these databases.

    The issue is TDP backups are not happening through agent.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply