Thursday, February 9, 2012

"Attempt to repair any minor problems." What is the point?

I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged=20
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on=20
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free=20
space)...
Rebuilding indexes for table 'AccessStatusMap'
.....................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:=20
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating=20
point exception occurred in the user process. Current=20
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC=20
execution completed. If DBCC printed error messages,=20
contact your system administrator.
=BFDo Anybody know, why is it the cause of this error?
Sincerely,
Ignacio
=20
>--Original Message--
>What is the point of having this checkbox on the Database=20
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to=20
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair=20
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be=20
running.
>For SqlAgent to be running, it requires NOT Single User=20
Mode.
>
>.
>My guess is you have some invalid float data in the table/index. Turn on
trace flag 2570 and run DBCC CHECKTABLE on the table in question. 2570
switches on some extra data range value checking of things like floats and
dates. FYI: this functionality is controlled by documented T-SQL in SQL
Server 2005 rather than a trace flag.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ignacio" <anonymous@.discussions.microsoft.com> wrote in message
news:1bfe01c44737$1dc83550$3501280a@.phx.gbl...
I have done a maintenance plan and I have this error:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged
on to SQL Server 'Cluster instance' as 'User' (trusted)
Starting maintenance plan 'DB Maintenance Plan5' on
31/05/2004 18:59:00
[1] Database xxxxxx: Index Rebuild (leaving 10%% free
space)...
Rebuilding indexes for table 'AccessStatusMap'
.....................
Rebuilding indexes for table 'TransactionPropertyMap'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3628:
[Microsoft][ODBC SQL Server Driver][SQL Server]A floating
point exception occurred in the user process. Current
transaction is canceled.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC
execution completed. If DBCC printed error messages,
contact your system administrator.
Do Anybody know, why is it the cause of this error?
Sincerely,
Ignacio

>--Original Message--
>What is the point of having this checkbox on the Database
Mainenance Plan
>properties (Integrity tab) window?
>
>For the plan to fix minor problems, it requires the db to
be in Single User
>Mode.
>"[Microsoft][ODBC SQL Server Driver][SQL Server]Repair
statement not
>processed. Database needs to be in single user mode."
>For the plan to execute it requires SQLAgent to be
running.
>For SqlAgent to be running, it requires NOT Single User
Mode.
>
>.
>

No comments:

Post a Comment