469,167 Members | 1,277 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Reindex maintenance plan fails after adding secondary data file

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:BatchStarting dbcc dbreindex(N'[dbo].[call]', N'', 90,
sorted_data_reorg)
SQL:BatchStarting 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

Jul 23 '05 #1
0 1624

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by GTM | last post: by
2 posts views Thread by Michael Nostrom | last post: by
5 posts views Thread by Jim Andersen | last post: by
2 posts views Thread by G.W. Lucas | last post: by
1 post views Thread by microsoft . public . sqlserver | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.