What kind of problems might I expect to encounter on applying the SP4 patch to an original installation of SQL 2000 (no upgrades applied)? I'm scared to death to apply it and am assuming out of the four downloads, it's 32 bit intel as it's and not the MSDE - it's the enterprise edition. I had someone else set up the server for me, but now I have to make sure it's up to date.
Anyway, I've been putting this off and know it needs to be done, but am wondering what it entails. The "Help/Instructions" are way over my head and need to know if I'll have to detach/reattach all the databases or if anything can go wrong that will put me out of business.
I can't even do it until I get a backup and the system is mirrored and I understand that it's not a simple thing to use Ghost and get a good backup, so I'm posting that as a question as well. I'm not sure where to post it under, though.