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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-03 : 07:42:50
|
| Moein writes "hi there,I have installed 2 different version of SQL server on my server and laptop, here is their info;on server :Microsoft SQL Server 2000 8.00.194 (intel x86)standard edition on windows nt 5.0 (build 2195:serveic pack 4)on laptop:Microsoft SQL server 2000 8.00.760Desktop engin on windows nt 5.1 (Build 2600: service pack 2)I would like to restore 'master' file which has been backed up from my server to my laptop, but I got this message:"Msg 3168 the backup of system database on device .. cannot be restored because it was created by different version of the server <134217922> than this server <134218488> .I'vq already installed service pack 4 (sql desktop edition)on my laptop but still I'm getting the same error message.thanks for your time, and waiting for help.regards,Moein" |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-03 : 13:41:24
|
| Why do you want to restore master on your laptop from the server. I assume that you want to do some testing, in that case just backup and restore the database you want to test. You don't need to restore master if you want to test another database. |
 |
|
|
|
|
|
restore master file