Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alternico
Starting Member
1 Post |
 Posted - 2008-07-25 : 06:39:14
|
Hello ...I have a database with SQL Server 2000 corrupt sector due to damaged discs.I tried to run dbcc in recovery mode and behold the output:-------Server: Msg 8966, Level 16, State 1, Line 1Could not read and latch page (1:8315) with latch type SH. sysindexes failed.DBCC execution completed. If DBCC printed error messages, contact your system administrator.-------You know?is very important ... are without backup and mdf is around 1GB! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-25 : 07:07:26
|
| moved to more appropriate forum._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-25 : 12:16:48
|
| No backup? Why not?If you have no backup and checkdb can't run, you're probably going to have to bcp out what data you can, script out what you can and recreate the DB. With sysindexes corrupt though, I don't know how much you'll be able to access.Maybe one of the corruption gurus has a better suggestion.Are you replacing the disks? Check any other DBs on the same server for corruption and get a backup strategy in place.At least it's a small database.--Gail ShawSQL Server MVP |
|
|
|
surya_rakanta
Starting Member
19 Posts |
|
|
|
|
|
DataBase corrupt -> Help!!