Restore fails due to different version

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restore fails due to different version

Author

Topic

Moussie
Starting Member

20 Posts

Posted - 2003-04-07 : 09:24:27

Hello!

I found a problem while testing our
restore-procedures for our databases.

we back up the msdb, master and a few user bases.

Now, to see if we will be able to actually restore
our data (would be nice) I did the following:
- Created a network of two computers and a hub,
one client and one server.
- The new network domain had the same name as the
domain with the original data. The server name
was NOT the same though, to make things more
interesting (or rather, because i forgot :)
- Installed the appropriate software.

Now, the original server has a year and a half on
its back so it has been through SP 1-3 on both
SQL and win2k server. The new server went straight
to SP3 on both.

No to the problem of restoring the master db to
the test-servere.
I fired up SQL2K with "sqlservr -m" to be able
to restore. I found some old (but SP3) backups
to use as my testdata. When I chose to restore
it gave me the message:

"The backup of the system database on device
c:\xxyyyzzz\master_backup cannot be restored
because it was created by a different version
of the server (134218488) than this server (134217922).
RESTORE DATABASE is terminating abnormally."

Now this is very strange, they are both SQL2KSP3.

Any ideas???

Best regards,
Moussie

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-04-07 : 12:46:31

Thye might both be service pack 3, but they aren't the same patch level. One of your servers has a patch or patches installed and the other doesn't.

Tara

Moussie
Starting Member

20 Posts

Posted - 2003-04-08 : 03:10:28

quote:

Thye might both be service pack 3, but they aren't the same patch level. One of your servers has a patch or patches installed and the other doesn't.

Tara

Hello!

When that is the case (I don't think my case is very special)
how can I find out either which patches are installed, or how
can I make them so that they get the same patch-level ?
Do I have to make an image of the original database-server ?

Regards,
Moussie

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2003-04-08 : 12:49:57

I had a similar problem
You may try getting the info on both servers using
SERVERPROPERTY ( propertyname )

If you run search in BOL for this function it will give you a list of server properties you can search.

I would say productversion and productlevel properties is where the answer lies.

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2003-04-08 : 15:15:34

select @@version on each should show you what you are looking for.

Jeff Banschbach
Consultant, MCDBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources