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 |
|
avilt
Starting Member
2 Posts |
 Posted - 2011-02-06 : 20:53:42
|
| I have my SQL Server 2000 with SP4 running on Windows 2000 OS.This database is maintained by vendor and I am not a database expert. I have been asked to upgrade the OS to Windows 2003/SP2.It seems like Server 2000 with SP4 is compatible with Windows 2003. But beofre the actual upgrade as a worst case scenario, I would like to take the full backup of SQL 2000. So I have taken the full backup of all the databases under management--> Database maintainance Plans.Do I need to perform any other tasks to recover the server in case the OS upgrade fails? I need to make sure that I have everything to recover the SQL server from the scratch.Appreciate your reply. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-02-07 : 01:04:44
|
| Got backups of the system databases too?--Gail ShawSQL Server MVP |
 |
|
|
avilt
Starting Member
2 Posts |
Posted - 2011-02-07 : 01:17:38
|
| I have taken the backup of all the databased inclusing Master, Model etc.Is it sufficient to recover the SQL server? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-02-07 : 04:44:44
|
| You should probably script out all users and their hashed passwords. Personally I'd script out all sql server agent jobs as well...http://support.microsoft.com/kb/246133- LumbagoMy blog-> www.thefirstsql.com |
|
|
|
|
|
|
SQL 2000 Disaster Recovery