Here is my understanding -

If you already have Management Studio installed, apply the normal Service Pack to it. If you do not have it installed and that is ALL...

Thanks for all your help. Things are much clearer now!

Thanks. One more question - The service pack for SSMS - is that to be used just for client updates? That would be an end user who only has the...

Thanks! Which leads me to anther question - do both need to be applied on a system that has SSMS and SQL Server 2008R2 installed or would just the normal...

Yes, it was tested and worked just fine. No problems with the application after the restore and testing went fine. 

Yes, it would make a difference on performance. I would go to an active\active set up. When we set up active\active cluster, we plan for add the total memory needed for...

After further research, I found that SQLServer 2005 backups include the full text catalog location and files. When restoring to a different location, you just add the full text catalog...

BTW - this is running under SQL Server 2005.

Thanks you all for your help.

Thanks Markus. This helped.

Well, I have found a KB artilcle (KB304282) that explains what to do. I was wondering if anyone else has had this issue? It would appear, based on this article,...

Congratulations and thanks for all you've done! The three of you have done very well. I understand that Steve is going to stay on and keep things pretty much the...

Steve is right - everyone needs to enjoy all that we have on this earth. We are very lucky to be able to see and enjoy these things. I would...

When you run the job, do you have an output error file specified? When you edit the job step there is an Advanced tab where you can put a path\file for...

How is the backup being performed- through a job? Have you tried using Q/A to run the command?