David,

The way I'm doing this is by copying over the database backup of the old server on to the new machine and then restoring it.

Are you saying I should do...

Unfortunately, renaming the new server to be the same as old won't work. Both will be online for a while until all testing is done. We'll only have a weekend...

All,

Thanks for your suggestions. It was probably a network issue. I copied the backup from our training machine in the same physical location as the development server. That finished in...

Wouldn't re-indexing take care of the corruption if present? There is only one index on the main table - a primary key on the CompID and SubCompID columns.

Copying the data...

When I do a select, I get back rows - instant response.

I was able to delete the rows last night after hours. I used the original statement. I first did...

Sugesh,

This is the statement:

Delete a from dbo.SubComponent a join ArchivedID b on a.CompID = b.CompID

I've tried the following too with no success:

Delete from dbo.SubComponent

where CompID in (select CompID...

Sugesh,

We did an update statistics and a re-indexing on that table. Didn't help.

Thanks,

VP

All,

I cannot do a truncate on the table.

There are three triggers - 1 for update and 2 for insert and updates. So, they should not be affected by this delete.

There...