I'm still working on recovering after a hardware crash. For a while I
had mismatches in actual and expected TEXT pages. But after reloading
the db in a different way, I don't now see those. However I still feel
insecure about the health of this db.

I created a 1gb device and a 200mb device (for the log). Then I created
the db for load with log on the second of these devices. sp_helpdb now
gives me this:

name db_size owner dbid created status
lsd 1200.0 MB burleigh 5 Jul 01, 2000 no
options
set
1 Row(s) affected

device_fragments size usage free
kbytes
------------------------------ ------------- --------------------
-----------
dev01 200.0 MB data only
204800
dev01 200.0 MB data only
204672
dev01 600.0 MB data only
584768
dev02 200.0 MB log only
204176

4 Row(s) affected

device
segment
------------------------------ ------------------------------------
dev01 -- unused by any segments
--
dev01
default
dev01
system
dev02
logsegment

4 Row(s) affected

I'm concerned about a mismatch between Syb Central and sp_helpdb. Syb
central shows a segment on dev01 as log, whereas the above does not.
How can I make sure the log is all on dev02?

In all other respects the db seems to behave properly with no dbcc
problems appearing, but I still have doubts.

--
Frank Burleigh
Indiana University School of Law
burleigh@indiana.edu