Re: error index data base

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 14:34:49 -0500

OK, I understand a little 'Spanglish'. If I read correctly, you have chosen
the 'Repair minor problems Automatically' option in your Maintenance plans
("Plan de mantenimiento de SQL" ). The repair tried and failed and marked
the database suspect.

First, this repair automatically option a bad idea and I think it should not
be in the product. I never check this option. I want to know if there is a
problem so I can schedule a fix during non-peak times. I also want to know
so I can find what is causing the error.

The good news is you may be OK. the ws_indexes are actually statistics and
do not directly impact the data. Look at 'Resetting Suspect Status' in BOL
(Books On-Line). This may let you extract your data and recreate the
database.

This KB Article may help if nothing else works.

INF: Bypass (Emergency) Mode and DUMP TRANSACTION WITH NO_LOG
http://support.microsoft.com/default.aspx?scid=kb;en-us;165918

Good Luck. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jose Rojas" <JoseRojas@discussions.microsoft.com> wrote in message
news:7592A326-4D93-4439-8BAB-1E95056C4809@microsoft.com...
> Hi all,
> I'm Jose and first of all excuse my english:
>
> I have many problems with "Plan de mantenimiento de SQL" often when the
> "Plan de mantenimiento" begin, have an errors during the reindex how:
>     Reconstruyendo los ¡ndices de la tabla 'ws_Albaranes_Lineas'
> [Microsoft SQL-DMO (ODBC SQLState: HY000)] Error 3624: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]
> [Microsoft][ODBC SQL Server Driver][SQL Server]Location: page.cpp:2831
> Expression: spaceContig >= Align (spaceNeeded)
> SPID: 54
> Process ID: 1284
>
> then marked how suspicous and can repair automatically, but when erros
like
> that occur for 4 or 5 times the database can't repair automatically and
the
> client lost data.
>
> W2K SP4 and SQL SP3
>
> Thanks a lot
>

Relevant Pages

  • Re: Blue Screen Crashes on XP install
    ... Enquire, plan and execute ... You could uninstall World of Warcraft and Spybot and then try running ... My original help request indicated that I'd tried a repair via recovery ...
    (microsoft.public.windowsxp.general)
  • Re: Right of way question
    ... situate on the grantors land in the approximate positon shown by the ... land shown hatched red on the plan as a car hardstanding together ... the right or obligation to repair and maintain it. ... logically any such obligation must fall on the landowner. ...
    (uk.legal)
  • Re: Italy withdraws from Durban II
    ... I repair cars, appliances, tvs, house electric and phone wiring, ... That the second conference was expected to implement ... The opposite plan reminds me a bit of Bush, before the 2nd Gulf war, ... or that whoever represented the US at Durban One did as ...
    (soc.culture.jewish.moderated)
  • Re: What is the best manufacturer and best type of RV to purchase?
    ... For a full time rig, then look to Excel, NuWa, Titanium. ... Jayco and plan on doing a bit of work to get it up to specs. ... motors a bunch with the big wind surface area. ... Too much to repair, too soon. ...
    (rec.outdoors.rv-travel)
  • Re: What is the best manufacturer and best type of RV to purchase?
    ... For a full time rig, then look to Excel, NuWa, Titanium. ... Jayco and plan on doing a bit of work to get it up to specs. ... motors a bunch with the big wind surface area. ... Too much to repair, too soon. ...
    (rec.outdoors.rv-travel)