SQL server 2000 move

Hello,

I'm in the process of moving a SQL Server 2000 to a new server. I have installed the new server added the latest sp. When I try to restore the system databases (Master, msdb) I get the following error

"the database xxxx.bak Cannot be restored because it was created by a different version of the server restore database is terminating abnormally"

I have looked at everything that I know of and both servers seem to be running the same versions of everything.

Can I just export the databases the the new server

thanks in advance for any help you can give.

Jason

They are both the same edition. both SQL server 2000 w/sp4. in fact they were both installed from the same orig. CD.

Jason

Madhu

thanks for the reply. I tried tranfering the logins and it said that it was seccussful but when I go into the users of the master DB they are not there. any ideas of what I'm doing wrong

thanks for you help.

if you are just moving to new hardware, same drive paths, same version, and same service pack. Then the easiest is to stop sql and rename the new server \data folder to something else. then stop sql on the old server and copy the data folder over to the new hardware. the only gotcha is if you change the servername it fubars the schduled jobs. so script out jobs then drop prior to move. or change servername.