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 |
|
Robwhittaker
Yak Posting Veteran
85 Posts |
 Posted - 2004-09-24 : 06:05:04
|
| Hi all,I've built a new sql server, and am wanting to totally copy all the databases from a different server over.I've taken a backup of the master database and have started the new server in single user mode.When I try to restore the backup of the master from the old server to the new server I get the following message. "The backup of the database on device <server name> cannot be restored because it was created by a different version of the server (number) than this server (different number). Restore database terminated abnormally"Both servers are developement servers and have sp3a installed. However the one which the backup was taken from was upgraded from v7 to v2000, but the second server was built as v2000.Any Ideas?ThanksRob |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-24 : 06:08:47
|
i'm not sure why you need to restore the master database, if you restore the other databases, and set the logins and all dependencies, the master database will accomodate these changes.just a thought or two... |
 |
|
|
Robwhittaker
Yak Posting Veteran
85 Posts |
Posted - 2004-09-24 : 06:15:06
|
| 2 reasons I want to do it like this;firstly it's a good chance to do a bit of a dr exercise2ndly there are lots of users whose passwords I don't know, so I don't want to go around recreating them all |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-24 : 06:26:21
|
| you don't need to recreate them...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=39129&SearchTerms=orphaned,users |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-24 : 12:55:07
|
| I never, ever restore the master database unless the restore is occurring on the same server where the backup occurred. For DR stuff, we have scripts to recreate the users. You don't have to know the passwords. The script handles it. Search the forums for sp_help_revlogin.Is there anything else from master that you need besides users?Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-24 : 13:23:02
|
| We've got some "execute at startup SProcs" in ours :-(Kristen |
|
|
|
|
|
|
unable to restore master database