Ok this is not a well documented subject and I have oftened wonder why but here's my take on it but I would like to understand it a little more...

I think I know exactly what you are talking about. They changed the way you see the errors in 2005 and it took me a little bit to figure it...

This is definitely true. I ran into this same issue last week and had to install integration services on the server to be able to schedule the job.

As far as the C drive size. I think we went from 8GB sizes to 16Gb sizes and this has been suffficent. However we usually install all sql related files...

I ran into the same exact issue with the PK error message when testing DR. What apparently happens is that since you did not gracefully uncheck log shipping from that...

Things to check when slow.

Check ping times between your host machine and your vpn and/or work ip address. 200ms+ is probably slow. This may be related to your providers network....

Did you say this was in a clustered environment? If so you will possibly need to apply the service pack to the tools on the physical nodes as opposed to...

I would think your restore times have more to do with I/O than with memory. Are the disks you are restoring to the same as the other server with 4...

Could you give a quick rundown on how to interpret the results properly. I am not entirely clear on how to read these the best way.

Thanks!

I think he is adding a additonal column in for the devlopers to use. I would say probably what you are looking for would be transactional replication.

My roughly 4GB (probably more) prod instance, takes about 10 minutes to run those tasks.

Tuning Wizard is a good tool, be careful with selecting to add indexed views though, as...

Laura,

Understand , devs are pushing me here to get the upgrade going. Trying to hold them wolves back as long as I can ...

Unfortunately I think you already have the answer. Drop recreate, re-import backup.

MM

I really do not think you will have a problem in this situation..  have done this before. if there is a high level of concern, I would contact MS just...

For the DR part, I am currently looking at their form of log shipping(database mirroring now) for the DR site. As far as consolidating 30 servers onto 2005... whew.. personal...