Decommissioning SQl Server

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  July 20, 2006 at 10:40 am

  #61425

  Can anyone please suggest some ideas as to what are the factors I need to check before decommission a cluster set up environment for sql 2000. Any suggestions will be greatly appreciated.

  TIA

• neotokyo

  SSCertifiable

  Points: 7239

  More actions

  July 20, 2006 at 1:46 pm

  #650512

  simply backup all databases including system databases, and you may

  want to make a note of any special configurations for the cluster

  environment.

  thats it.

  cheers

  _________________________

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  July 21, 2006 at 11:59 am

  #650818

  Make notes of:

  • Server OS, SP and hotfixes installed
  • SQL Version, SP and hot fixes installed
  • Cluster configuration (google the 'cluster' command)

  Get backups of:

  • Windows 'system state' - the registry
  • Full backup of both nodes - OS backup at a minimum
  • Full backup master, model, msdb database
  • Copies of all DTS packages stored outside of SQL Server
  • Full backups of all your user databases

  Other things to consider:

  • Scripting out all logins
  • Scripting out all server roles and their members
  • Scripting out all linked servers
  • Scripting out all remote logins

  Replication is another whole ball of wax as well.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."