December 8, 2006 at 4:49 am
Hi All,
someone kindly help me out on this SQL 2000 issue,
I installed SQL Server 2000 on a new machine and want to move all Databases on the old machine onto the new one, so I took a backup of all the Databases including the Master, msdb, and model, but when I tried restoring them onto the new server, It gives an error that SQL server versions are different but they are both Enterprise Edition Version 8.0
With Copy Database Wizard it says those databases already exist or system databases, how do I go around this.
Thanks and have a great day.
Chao
Jackie
December 8, 2006 at 4:52 am
It gives this ids (134218488) and (134217922) for the old and new servers respectively.
December 8, 2006 at 8:06 am
Remember, it is okay to restore a user database with old service pack to a server with a later service pack. You may have an error if you do it in an opposite direction. For the system databases, you need to have the same service pack on the both servers.
December 8, 2006 at 2:02 pm
To restore the system databases you have to have the same build on destination as source.
Run select @@version command and make sure you have the same sql version and build.
For user database there is no problem restoring 2000 to 2000 on different builds without any issues...
You have follow special considerations when you restore master database where msdb can be restore like a user database but make sure sql agent is offline.
Do you have the same directory structure on both machines? After restoring master, SQL Server
will look in prod machine's directory for model etc. If it cannot find it there, SQL Server
cannot start.
You cannot restore system database backups to a different build of SQL Server
http://support.microsoft.com/default.aspx/kb/264474
How to move databases between computers that are running SQL Server
http://www.support.microsoft.com/kb/314546
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply