Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-09 : 10:28:59
|
| Fred writes "We are preparing to install SP2 for SQL Server 2000. We think this is the latest SP and is the correct one for us to install. Is our thinking correct on this? We also think we need to backup the master, msdb and model databases prior to installing the SP. IS this correct? We have our initial version of our production database on the system now but it is not in production, we will still be doing some testing with it. We have no major scheduled tasks setup or DTS packages or full-text catalogs etc.. But we do have a few important logins. How do we protect these in case we need to restore? Is there anything else we need to backup to insure recovery? Are there any tips you can offer on the installation of SP2 for sql server 2000? Thank you!" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-05-09 : 10:56:03
|
| SP2 is the latest and greatest for SQL 2000. There are some very good instructions in the Readme.html file that comes bundled with the Service Pack. It describes in details what databases need to be backed up, what services need to be shutdown, and how much space is needed for the upgrade. As far as logins go, they can be scripted. Check the scripts forum for more info on that.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
Service Packs Installation Preperation