my disk was bad.I found the data files from the disk. but the data files maybe have a problem. Can not Output the data. so who can tell me how to repair???
thanks!!!

You might want to look up DBCC CHECKDB on SQL Server Books Online.

Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup


"kingbobo" <kingbobo (AT) discussions (DOT) microsoft.com> wrote

repair???

It all depends on the what the installation looks like at the moment. Depending on your state, you might have
to reinstall the OS, SQL Server. Also, you might have to restore your latest backup. Or possibly only read in
the updated books online about your specific error number. If you do not feel comfortable repairing this, I
suggest you get a consultant to help you out, or open a case with MS Support.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"kingbobo" <kingbobo (AT) discussions (DOT) microsoft.com> wrote

Hi,
IF you are having any hardware/firmware issues on the box then the first
and foremost thing to do is to contact the hardware vendor and get them to
run the diagnostics against both hardware and firmware and have them fix
any issues that are there. It is VERY important for SQL server to have a
stable environment to function efficiently.
Once the hardware is clean and firmware if up to date then you should try
to repair the database. If you try to do the repair with existing hardware
issues the chances of recurring corruption are high and it can be that soon
after you are done repairing, corruption can re-occur. And if the
corruption hits system databases then it is really fatal.

For corruption issues the first option that we recommend is restoring from
last good backup. If that is not an option for you then you can try to
repair.
For repair run DBCC CHECKDB without any repair options and see what type of
repair option does the output recommend.
If it recommends repair_allow_data_loss then you know that it will involve
some data loss and there is no telling how much of the data will be lost.
SO it is up to you and how familiar you are with the data in the database.
Also it depends which file you have corruption on . Is it the data file or
the log file? There are lots of options that you can take when doing a
repair. If you are not familier/comfortable with all the steps then I
would recommend contacting microsoft support for assistance.
Hope this helps!
Thanks
Manisha