Post reply

dbcc checkdb ("master") with no_infomsgs runs forever, does not stop

  • April 2, 2015 at 11:06 am

    #398273

    Hello,

    When I run dbcc checkdb ("master") with no_infomsgs the command runs forever. I had to stop it after 14 hours and 24 minutes, but it would have kept going.

    It used to end after 5 minutes on the master database, which 4 MB in size.

    Are there other commands that can be used with DBCC to find out what is going wrong? SQL server log files say nothing, only that the command started.

    Thanks,

    Paul

  • April 2, 2015 at 12:47 pm

    #1788415

    Strange. Consistently reproducible?

    Can you reboot the instance/host and try it? I'd learn towards transient error unless it continues.

  • April 2, 2015 at 2:03 pm

    #1788425

    I plan to reboot the server to free up memory. There is not enough memory to run the DBCC command.

  • April 4, 2015 at 3:13 pm

    #1788776

    pbyrum (4/2/2015)

    I plan to reboot the server to free up memory. There is not enough memory to run the DBCC command.

    Quick question, what are the server's specs and configs?

    😎

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

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