cap max server memory to 12GB and apply sp3 CU4 which will be coming soon and add lock pages in memory

it should help

is it 32 bit or 64 bit?

how much ram you have in the box?

this might help

http://www.microsoft.com/Downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en

whats is the name of the xp which is missing? is it msshipped XP?

resource db is a read only DB and it doesnt hold any data other than the schema defination.

i am quite surprised that you said that you ar enot able to...

i would suggest lets run a command like

while(1=1)

select * from master.dbo.sysprocesses

wait for delay 00:00:15

this is a snippet , syntax not checked and then run at night and populate to...

run

select * from sys.dm_exec_requests

check the command column and find DBCC keyword and find the value of

percent_complete for that row.

that gives a approx percent value

As you said that the DB goes to suspect now and then and also the h/w check came clean.

Only thing I can think of right now is disk controller....

let us know the outcome by tomorrow and please pay attention to the more info section

To enable this hotfix, you must turn on a 1903 trace flag.

After you apply...

First Page the output of summary.log

try this

http://support.microsoft.com/kb/911678/en-us

CHECK your disk controller and find if disk caching is enabled or not?

though your explanation of the issue is bit vague.

If you want to restore the database and wants to bring the DB online

use the CREATE DATABASE

and with force attach...

paste the compl;ete error message. there has to be an error number associated with this error

can you send the errorlogs. i can have a look and give you any suggestions .