March 2, 2009 at 1:03 pm
Hello,
I would like to move the data from a user database from one machine running sql server 2000 to a new machine running 2008. There's all kinds of info out there about restoring the master database, model, msdb, even Northwind! to the new 2008. I just don't know that I really need to do that. The new database really is going to be a new database: new users, new functionality, everything. I just need that old data on the new machine. Is there any reason why I can't just restore mydatabase to the new machine?
A guy at IT got me a little freaked out that the server (machine) name is somehow embedded in the database, and just restoring it to a new server with a new name won't work.
Thoughts? Comments?
Thanks so much,
katherine 🙂
March 2, 2009 at 1:06 pm
You can restore a backup of a SQL 2000 database to a SQL 2008 server.
March 2, 2009 at 1:09 pm
Thanks! I'll try not to get so easily freaked out next time.
🙂
March 3, 2009 at 6:24 am
Backup and restore works just fine. You can also detach, copy and attach as an upgrade process. Whichever you end up doing, just make sure you run it through the Upgrade Advisor 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
March 3, 2009 at 7:33 am
Don't forget to change database compatibility level to 100 after restoration so that you can enjoy the new functionalities present in SQL Server 2008.
MJ
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply