Time-out occurred while waiting for buffer latch type 2 for page

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Notification Services » Administration » Time-out occurred while waiting for buffer...

Time-out occurred while waiting for buffer latch type 2 for page

Rate Topic

Display Mode

Topic Options

Author

Message

zayousafi

Posted Monday, April 13, 2009 2:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 12, 2012 6:04 AM
Points: 1, Visits: 33

Hi, I am facing a strange exception from SqlServer. All the DML queries work fine and provides result normally. But when i try to get the schema of my DB either through Microsoft SQlserver Management Studio or by executing Information_Schema.Tables Query, I am getting following exception
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Time-out occurred while waiting for buffer latch type 2 for page (1:68), database ID 18. (Microsoft SQL Server, Error: 845)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=845&LinkId=20476
all other DBs on the same server works fine. Any Idea what is happening and how can I fix this problem

Post #695589

seven.srikanth

Posted Saturday, January 28, 2012 3:33 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:29 AM
Points: 33, Visits: 373

Try adding one more data file to the database in to a new disk where you have got good amount of place.

We got the same error and the above work around fixed it.

Post #1243195

« Prev Topic | Next Topic »

Permissions