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 |
|
d3ng
Yak Posting Veteran
83 Posts |
 Posted - 2007-07-12 : 04:19:25
|
| Hi experts, I would like to ask for this error that occurs upon executing my reindexing scripthere is my scriptUSE mydatabaseDBCC DBREINDEX('outpatient', '', 70)goThen this error message will appear. I researched for this error and from the site that I've found they say that the table is corrupted? That I need to restore a better backup..?The statement has been terminated.Msg 824, Level 24, State 2, Line 1SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x55555545). It occurred during a read of page (1:353409) in database ID 10 at offset 0x000000ac902000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Bizbox_HS7.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.Darren Bernabe Blanco |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-12 : 04:43:14
|
| first run dbcc checkdb and after that try to restore the database, but if you can not afford to go back to an earlier backup you can also try the same after you made an backup of the current database!dbcc checkdb ([yourdb], REPAIR_REBUILD) if that does not work try dbcc check db ([yourdb], REPAIR_ALLOW_DATA_LOSS)good luck.P.s the last option can cause data loss!!Need an SQLDB consultant?check www.veeningsengineering.nl |
 |
|
|
d3ng
Yak Posting Veteran
83 Posts |
Posted - 2007-07-12 : 05:12:03
|
| I tried what you suggest this message appear...Msg 7919, Level 16, State 3, Line 1Repair statement not processed. Database needs to be in single user mode.what does this message means..?Darren Bernabe Blanco |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-07-12 : 05:23:02
|
| It means the database needs to be in single user mode.Have a look at the alter database command.(Have yo backed up the database before trying this?).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
d3ng
Yak Posting Veteran
83 Posts |
Posted - 2007-07-12 : 06:38:34
|
| Ok. I got it, it is in the property of the database. Thanks a lot!Darren Bernabe Blanco |
|
|
|
|
|
|
|
|
Reindex Error