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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-15 : 07:51:29
|
| Sebastian Garibaldi writes "Hi I'm Sebastian from Argentina, and i have a problem with a SQL data base. I receive error from data base of broken index and consistency errors. I set the fill factor with the information from the books online, i put 70 in tables that have a lot of INSERT/UPDATE/DELETE but it works for two o tree days.I now that i must make some maintain in the database but which tools i shuld use?here i paste an error from dbcc checktable:Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 981108969. The text, ntext, or image node at page (1:949979), slot 52, text ID 57535781339136 is not referenced.Server: Msg 8964, Level 16, State 1, Line 1Table error: Object ID 981108969. The text, ntext, or image node at page (1:949979), slot 53, text ID 57535782191104 is not referenced.DBCC results for 'FCRMVI'.There are 108460 rows in 17430 pages for object 'FCRMVI'.CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'FCRMVI' (object ID 981108969).repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (ArleiProd.dbo.FCRMVI ).thanks, and sorry my english." |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-08-16 : 13:07:40
|
| Can you run the following command and post the results:DBCC CHECKDB (ArleiProd) WITH NO_INFOMSGS, ALL_ERRORMSGSAlso, which version are you running?ThanksPaul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
|
|
Maintain a sql data base