Post reply

Strange DBID

  • November 20, 2013 at 7:05 am

    #280396

    Hi Experts,

    We were running CHECKDB on one particular database and when ran sysprocesses we saw one SPID is running against DBID=13 ,checked again and again in server that we dont have a DB with ID=13.

    Can anyone please help resolving this?

  • November 20, 2013 at 7:12 am

    #1667796

    I think its because it create a snapshot internally

  • November 20, 2013 at 7:13 am

    #1667798

    When you run DBCC CHECKDB it creates a hidden database snapshot. The strange DBID may just be the database snapshot that was created by DBCC CHECKDB.


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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