Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Time-out occurred while waiting for buffer latch type 2 for page Expand / Collapse
Author
Message
Posted Monday, April 13, 2009 2:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Saturday, January 28, 2012 3:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 5:50 AM
Points: 38, Visits: 457
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 »

Add to briefcase

Permissions Expand / Collapse