Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leodone
Starting Member
30 Posts |
 Posted - 2010-10-15 : 16:38:23
|
| I am new to the sql server database world. I needs some question to be answered.I have two servers, Server1 has sql server 2000 and Server2 has Sql Server 2005.Server1 - we are getting rid of it and its a 32 bit serverServer2 - is a 64bit serverWhat I want to do is to bascally detach those sql 2000 database and attach it to Sql server 2005.Question:1) Can this be done? Or do I have to upgrade the databases first?2) what would be the best step for this process?3) Is there a wizrid in SQL 2005 that I can use to upgrade database before attaching them sql server 2005?Please help.Thanks, |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-10-15 : 17:30:57
|
| The easiest way to move the database from SQL 2000 to 2005 is to make a database backup on the 2000 server, and restore that backup on the 2005 server.The database will be converted to 2005 format as part of the restore.Note that you cannot move a database back from 2005 to 2000.CODO ERGO SUM |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-15 : 17:52:02
|
| by the way, detach/attach will work just fine, but I agree with Michael that its easiest to backup/restore. Safer too.Just remember to make sure to get tail of the log backups if any of your databases are in full or bulk-logged recovery model |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-16 : 02:43:23
|
| There are some things you need to do after moving a database to a new version, for example:Reindex / update statsConsider changing compatibility modePerform regression testDetails here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230(This is specifically for SQL2008, but as noted in that post most applies to SQL2005)P.S. For me, given the work involved in a migration, particularly the regression test, and I personally would want to move directly to latest version (SQL2008 R2) at this time, not have to move again in a couple of years time. |
|
|
|
leodone
Starting Member
30 Posts |
Posted - 2010-10-18 : 10:38:19
|
| Thank you everyone for this info. I will testing this our before I move the database. |
|
|
|
|
|
|
Upgrade sql 2000 database to sql 2005