Verifying Data Integrity in SQL 7

[monsy]

I' running SAP managed by SQL 7.0 on windows NT 4.
This is running on an HP Netserver LH 3.
My disk configuracion is as follows:
Drive c:\ Array 0, Raid 0. 18.2 GB 8 GB Used for NT.
9.3 GB free.
d:\ Array 1, Raid 0. 18.2 GB SQL erver.
e:\ Array2, Raid 1. two 18.2 GB SAP software & and transaction logs.
g:\ Array 3, Raid 0. two 18.2 GB Data.

One of the disks in drive "g" keeps going off line. I've checked the consistency of the disk an it checks out ok.
But somehow The disk keeps going off line and my event viewer give's me the following errors.

The description for Event ID ( 22 ) in Source ( hpgate ) could not be found. It contains the following insertion string(s): , MPS 1.4 - APIC platform, .Translated.

The following boot-start or system-start driver(s) failed to load:
hpgate
qntmdlt

Application popup: System Process - Lost Delayed-Write Data : The system was attempting to transfer file data from buffers to \Device\Harddisk3\Partition1\RECYCLER\S-1-5-21-1036340895-2134398797-925700815-1028. The write operation failed, and only some of the data may have been written to the file.

Finally my question. How can I check my data integrity with SQL 7.0?

 

[fluteplr]

Try running the following from query analyser on some of you databases:

dbcc checkdb

and then run through the results for an error, look at the bottom first it will tell you how many errors (if any) where found.

Note: if your databases are large or your server is busy this may take quite a while.