I can see these controller errors around the time we lost the database:

SCSI bus fault occurred on Storage Box box 0, , Port 1 of

Array Controller in slot...

as far as I can see from the SQL event log this database recovered successfully after the reboot after the failed disks:

Message

Recovery of database 'EQMCLOGRestore' (8) is 100% complete (approximately...

oops forgot the put the array controller warning:

"The current array controller had valid data stored in its battery backed write cache the last time it was reset or was powered...

Hi Gail

The I: drive is there and accesible and I can write a file to it. I can even change the name of the data and log files so it...

although its only a work area I would still keep one backup on local disk just in case you need to recover for some reason. You never know, you may...

yip. I'll save NYSE the cash.

btw - I was at your Surviving Corruption session at PASS. It was the best session I attended. As you can see I still...

Great tip. It would be nice to also get a warning in the error log if a CHECKDB has never been run against the databases.

Alan Cranfield

this is an old server where we weren't running regular DBCCs but from now on I will. 🙁

Hi Gail and Paul

Thanks for the reply. I restored from our backup and ran DBCC CHECKDB with NO_INFOMSGS again and we still have corruption:

Msg 8909, Level 16, State 1, Line...

I have gone with the RESTORE. Data loss was not option. cheers

please note this is a SQL2000 instance - I posted to the wrong forum. sorry.

BCP them out. We do that daily filtered on day. works great for archiving. be sure to use native mode and create an fmt file too to assist you when...

Turns out this was due to compression being set on the folder where the dump was being written to. Experience tells me never to have this setting, especially for large...

Litespeed backups. MSSQL supports multi-terabyte databases. Petabytes actually.

backup database database_27 to disk = 'c:\file1.bak', disk = 'c:\file2.bak',disk = 'c:\file3.bak'