Our system just started receiving an error on the
optimization phase of backup maintenance plan. This is
during index rebuild.
[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.
This system is Sql2k SP3. I have found a couple of hits on
floating point errors, but nothing directly related to
index rebuilds.
Any ideas?The first thing I'd do is to check if the database is clean using DBCC
CHECKDB and DBCC CHECKCATALOG.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Judy" <jranson@.harris.com> wrote in message
news:015a01c3be88$b4c5afb0$a401280a@.phx.gbl...
> Our system just started receiving an error on the
> optimization phase of backup maintenance plan. This is
> during index rebuild.
> [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.
> This system is Sql2k SP3. I have found a couple of hits on
> floating point errors, but nothing directly related to
> index rebuilds.
> Any ideas?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment