SQL 2000 Disaster Recovery

Viewing 1 post (of 1 total)
  • Author
    Posts
  • Avatar
    avilt
    Member
    #153246

    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.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.