Post reply

SqlServer Startup Recovery "Waiting for Buffer Latch type 2" FOREVER

  • March 10, 2005 at 6:18 pm

    #87002

    I run "sqlserver -c" from the command line.

    The database starts up and begins its checkpointing/recovery of all the databases within until it gets to one database that it feels it needs to restore some transactions for.

    so it begins a 3 phase process of analysis and recovery of the transactions yet to be written to the database.

    This is all fine, except that it never gets to write the data to the disk because now it gets a timeout, specifically:

    "Time out occurred while waiting for buffer latch type 2, bp...(yadda yadda)...Continuing to wait"

    followed by:

    "Waiting for type 0x2,..."

    These messages just cycle ad nauseum.

    So the question:  how do I bypass this latch buffer issue so the database starts up?

  • March 10, 2005 at 6:39 pm

    #546517

    Try this article

    http://support.microsoft.com/kb/310834

     

    --------------------
    Colt 45 - the original point and click interface

  • March 10, 2005 at 7:28 pm

    #546521

    Thank Phil, but I went to every place in microsoft land and most everyplace that Google turned up when i Searched for

    "time out occurred while waiting for buffer latch type 2"

    no one has an answer - they all have referrals to MS Tech pages.

    This is not a system under normal operating load - it occurs on startup.  I cannot get past this recovery process and I don't know enough about sql server transaction logs to experiment.

    Anyone have any experience with this?

     

  • March 10, 2005 at 7:51 pm

    #546524

    Did you look at the workarounds listed in the article? Are you able to satisfy all the non-SQL Server items such as compressed drives, etc... ?

    You could try moving the files for the database in question to another folder. This could at least allow you to start SQL. Once started, that database will be marked as suspect, but you can just remove it. Check the server settings as suggestef in the article.

    Once everything is checked, copy the database files back to their original location and try attaching the database using sp_attach_db.

     

     

     

    --------------------
    Colt 45 - the original point and click interface

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

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