Restore SQL 2000 DB in SQL 2005

• ssa2010

  Old Hand

  Points: 365

  More actions

  February 7, 2012 at 4:23 am

  #145027

  friends,

  If any problems when restore sql 2000 db in sql 2005

  and

  Please explain the issues faced when we upgrade sql 2000 db to sql 2005

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 7, 2012 at 4:57 am

  #1443671

  No issues AFAIK.

  Keep in mind this is a one-way path: you will not be able to restore the database in SQL 2000 from a backup set taken in SQL 2005.

  Hope this helps

  Gianluca

  -- Gianluca Sartori

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  February 7, 2012 at 5:33 am

  #1443695

  I suggest you read the following before upgrading.

  http://msdn.microsoft.com/en-us/library/ms144267(v=sql.90).aspx

  And understand the effect of the upgraded database by reading about the compatability mode at:

  http://msdn.microsoft.com/en-US/library/ms178653(v=sql.90)

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  February 7, 2012 at 5:38 am

  #1443698

  Nope, not a single issue at all. Great way to do the upgrade. I've done... oh, a whole bunch that way.

  However, you should run the Upgrade Advisor first because there are things that can create problems for you. Find them out before hand.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  February 7, 2012 at 6:28 am

  #1443727

  ssa2010 (2/7/2012)

  ---

  friends,

  If any problems when restore sql 2000 db in sql 2005

  and

  Please explain the issues faced when we upgrade sql 2000 db to sql 2005

  No issues apart from maybe the compatability level. After the upgrade upgrade has completed, ensure you run

  DBCC UPDATEUSAGE

  and

  DBCC CHECKDB() WITH ALL_ERRORMSGS, NO_INFOMSGS, DATA_PURITY

  You'll also want to check the indexes and stats are up to date too.

  After this you can then sort out any orphan users

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉