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 |
|
infisf
Starting Member
8 Posts |
 Posted - 2004-05-31 : 13:52:53
|
| I have executin a maintenance plan of MS SQL Server 2000 sp3a. It's an instance in failover cluster.I am doing a rebuild index. The log is the following:Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'Cluster\Instance' as 'Domain\User' (trusted)Starting maintenance plan 'DB Maintenance Plan5' on 31/05/2004 18:59:00[1] Database Database_Name: Index Rebuild (leaving 10%% free space)...Rebuilding indexes for table 'NameTable 1'.. .. .. .. .. .. .. .. .. .. .. .. .. ..Rebuilding indexes for table 'NameTable n'[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. ** Execution Time: 0 hrs, 7 mins, 5 secs **[2] Database Database_Name: Removing unused space from the database files (if database size is more than 50 MB). Reducing free space to 10 percent of data... ** Execution Time: 0 hrs, 0 mins, 1 secs **Deleting old text reports... 0 file(s) deleted.End of maintenance plan 'DB Maintenance Plan5' on 31/05/2004 19:06:35SQLMAINT.EXE Process Exit Code: 1 (Failed) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-01 : 13:11:25
|
| What happens if you run DBCC DBREINDEX outside of a maintenance plan?Tara |
 |
|
|
|
|
|
A floating point exception occurred in the user pr