Moving from SQL Server 2005 to 2008

• david.c.holley

  SSCrazy

  Points: 2423

  More actions

  December 4, 2008 at 7:42 pm

  #383514

  I installed SQL Server 2005 developer version on my old PC for the sake of learning more about SQL Server.When I replaced the laptop, I made a back up of one of the databases to hold onto some of the exercises that I had done. Can the backup be used to create a new database in SQL Server 2008 on the new laptop? (or am I SOL).

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  December 5, 2008 at 1:26 am

  #908093

  You can restore the backup to 2008. Databases can always be upgraded in version, never downgraded.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• david.c.holley

  SSCrazy

  Points: 2423

  More actions

  December 5, 2008 at 6:10 am

  #908215

  So how do I do a restore if the database doesn't exist already exist on the server? When I right click on the Database parent node and select 'RESTORE', the Restore Database window requires that I select an existing database.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  December 5, 2008 at 6:21 am

  #908225

  It looks like it needs an existing DB selecting, but you can type a new DB name into that box

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• david.c.holley

  SSCrazy

  Points: 2423

  More actions

  December 5, 2008 at 10:03 am

  #908462

  Looks like that did it, I just kicked it off. Seems to easy that MS would actually add text to the window to enter the name of a new database...