I have read about some issues such as running twice as long after SP4 has been applied. We are currently running SP3a. Are you SP4 yet?

SQLBill,

Do you notice, over time, any degradation? I believe the defrag only reorgs the pages that are not intertwined with other indexes.

When you did the initial full restore, did you specify the NORECOVERY option?

The only other thing to look at is constraints. You may need to disable/enable when trying to restore the data to the table.

Was the backup taken from that database on that server? Or was taken from another server and you are restoring it to this server? Or was it taken from another...

I would check with the vendor, as the application may not let you change it. If the application is doing bcp or something similar, it may not let you run...

I believe when you renamed this SP to "dbo.proc1_bak' Sql Server added the SCHEMA identifier of DBO to the beginning of the name you keyed in, thus giving you 'dbo.dbo.proc1_bak'....

I have seen answers to posts here from these same members that have taken this same tone. I understand frustration with some elementary questions, but please try to be nice...

Sometimes when comparing queries on different servers, the physical characteristics make a difference. You mentioned that the number of CPUs in each server is different. If you have more CPUs...

I would be interested in knowing how you did this restore. I think when the restore was done, the with move options were probably incorrect.

I used to be one of the people whose ethics prevented me from taking a 'sick' day for metal health or just burnt out. But after having worked in the...

You can tell by running select @@version in query analyzer from the master database in the instance in question. If the output is 2000.80.760 or higher, then you SP3 applied.

I've had a few "ODD" things happen with that release. I just installed version 4.0.8.5 and it seems to be more stable. You may want to install the latest release...

Have you tried reinstalling the Client Tools? Also, are you using the standard SQL Server port number? If not, that could be part of the problem.

When I need to do this, I will install SQL Server software on the new server. Once I get the server set with the software, I will take backups of...