Moving from SQL 2005 to SQL 2008

• carloarango@hotmail.com

  SSChasing Mays

  Points: 628

  More actions

  September 15, 2011 at 10:20 am

  #247855

  We are going to move our production SQLs from SQL 2005 Standard edition to SQL 2008 Standard Edition; we are moving to a completly new box, so the plan is to do a restore from backups; what is the best way to approach the move of the following:

  - MSDB

  - Login Information from Master

  - Replcation - we are currently replicating a database in the same box for reporting purposes

  Any suggestion would be greatly appreciated.

  Thanks

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  September 15, 2011 at 10:41 am

  #1382134

  http://msdn.microsoft.com/en-us/library/ms189625.aspx

  http://msdn.microsoft.com/en-us/library/ms143699.aspx

  http://technet.microsoft.com/en-us/library/ms143699.aspx

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/