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 |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-08-15 : 11:58:08
|
I"m trying to restore the Master Database from our old SQL Server 2000 database and put it onto a new server with SQL Server 2000. However I kept getting this error:The backup of the system database on device C:\Documents and Settings\administrator\Desktop\bkpMaster.BAK cannot be restored because it was created by a different verions of the server (134218112) than this server (134217922). RESTORE DATABASE is terminating abnormally. Not sure if this relates to different SP for SQL Server or different server OS? The original Master DB was in Windows 2000 Advanced Server while the new one is in Windows 2003 Enterprise server. As for service pack version for SQL, I had tried to install a fresh copy of SQL Server without any service pack and it still gives me the same problem. Can anyone assist me? Thanks in advance. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-15 : 12:42:50
|
| Why not just migrate the server logins and and runn sp_attach_db or whatever it is on the databases? I would test it out before you do it.====================================================Regards,Sean RoussyThank you, drive through |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-08-15 : 13:33:49
|
| Thanks for the feedback. Migrating user logins and passwords might not be a bad idea. I will look into that.As for the sp_attach_db, I wouldn't want to do that yet since the database is still in production. What I did was do a database backup and try to restore it from there, but the problem I encountered with the Master database is as my original post. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-15 : 15:05:53
|
| Chris,It is highly not recommended that you restore the master database onto any other server. There is no way to get around the error except to make the other server the same version as the original. It is referring to the SQL version. If the old server has sp3a plus 818 on it, then that's what you need on the new one.Tara |
|
|
|
|
|
|
Need help restore Master DB