Hello all, I have a SQL 2000 Standard SP3 install. I was running low on
free space so added a secondary data file on a separate hard drive. I
did this for each of two databases.
Since then, and I guess it could be only a coincidence, my weekly
reindex maintenance plan has been failing, but only for one of the two
databases I added the secondary file to.
The 1st weeks emailed report shows that it rebuilds indices for 12
tables and then tries to rebuild indexes for a table named 'call'. At
that point the report shows:
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0: This server has
been disconnected. You must reconnect to perform this operation.
The job locked up and only finished when another job ran which turned
on full logging using an alter database command.
The 2nd week I ran a trace and at the crucial point it captured this
SQL:BatchStarti ng dbcc dbreindex(N'[dbo].[call]', N'', 90,
sorted_data_reo rg)
SQL:BatchStarti ng SELECT N'Testing Connection...'
The first batch never completes and lots of 'Testing Connection'
commands occur until the job is aborted.
A DBCC CHECKDB command shows no errors. Can anyone help me with what
could be causing the disconnected state with that table and how to
remedy it
Regards,
Todd
free space so added a secondary data file on a separate hard drive. I
did this for each of two databases.
Since then, and I guess it could be only a coincidence, my weekly
reindex maintenance plan has been failing, but only for one of the two
databases I added the secondary file to.
The 1st weeks emailed report shows that it rebuilds indices for 12
tables and then tries to rebuild indexes for a table named 'call'. At
that point the report shows:
[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0: This server has
been disconnected. You must reconnect to perform this operation.
The job locked up and only finished when another job ran which turned
on full logging using an alter database command.
The 2nd week I ran a trace and at the crucial point it captured this
SQL:BatchStarti ng dbcc dbreindex(N'[dbo].[call]', N'', 90,
sorted_data_reo rg)
SQL:BatchStarti ng SELECT N'Testing Connection...'
The first batch never completes and lots of 'Testing Connection'
commands occur until the job is aborted.
A DBCC CHECKDB command shows no errors. Can anyone help me with what
could be causing the disconnected state with that table and how to
remedy it
Regards,
Todd