December 4, 2008 at 7:42 pm
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).
December 5, 2008 at 1:26 am
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
December 5, 2008 at 6:10 am
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.
December 5, 2008 at 6:21 am
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
December 5, 2008 at 10:03 am
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...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply