SP3a

• dave109

  SSC Enthusiast

  Points: 131

  More actions

  March 8, 2005 at 9:30 am

  #163754

  I currently have a server running SP3.  We have purchased a new server that will become the SQL server.  All data on existing will be moved to new server.  Is it OK to apply SP3a to the new server and then move the data over?  Or, do I have to move the data and then apply SP3a?

  Any suggestions are appreciated.

  Thanks,

  Dave

   

• Jim P.

  SSCrazy Eights

  Points: 8725

  More actions

  March 8, 2005 at 12:42 pm

  #545985

  There shouldn't be a difference either way you do it.

  Per SQL Server 2000 Service Pack 3, Service Pack 3a, or Service Pack 4 pre-installation checklist for SQL Server 2000 virtual server for failover clustering

  However, if you have instances that have not been
  upgraded to SQL Server 2000 SP3, you must upgrade
  those instances directly to SQL Server 2000 SP3a
  instead of SQL Server 2000 SP3. 

  Good luck.

  
  
  ----------------
  Jim P.

  A little bit of this and a little byte of that can cause bloatware.

• dave109

  SSC Enthusiast

  Points: 131

  More actions

  March 8, 2005 at 12:47 pm

  #545986

  Thank you for your reply.

  Dave