Index creating

[Tassajara]

Hi,

I'm trying to create several indexes on several tabels. A few of them work fine but one them causes troubles.

Whem I'm using QA to do so I get the following message:

Time out occurred while waiting for buffer latch type 2 for page (21280:1952999273), database ID 10, object ID 62623266, index ID 0.

I don't know where to look for the solution.

Thanks in advance,
Tassajara

 

[cheyney]

heres a couple links that discuss what you're encountering:

http://dbforums.com/arch/175/2002/3/319679

http://www.storageadmin.com/Articles/Index.cfm?ArticleID=14136

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_2a45.asp

i just did a google search for "Time out occurred while waiting for buffer latch type" (with the quotes)

cheyney

 

[Tassajara]

Hi Cheyney,

Thanks for your help.
The problem is solved! The server had some severe problems, these are fixed and the indexes are created.

Tassajar