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 - 2002-01-31 : 09:09:33
|
| Lynda writes "I tried to move several databases and their users from one server to a new server, both servers are alive.This is what I did are,1. Install SQLserver7 on new server, c:\MSSQL7, same as old one. 2. Restore application databases from backup that I had on old server. worked.Here is my question, can I restore users from master DB on the new server from old server's backup? Someone told me yes. So I did,3. Stop SQLserver and restart in single user mode by issuing 'sqlservr.exe -m'. 4. In query Analyzer, I did 'restore database master from ... with recovery'. Messages showed me 'successed'.5. But in step3's cmd window , it shows there is a I/O error, I fixed, but it's too late. I cann't restart SQLserver service.Do I have to remove all master.mdf, master.ldf to be able to rebuild master? I guess I forgot, I did,6. Run 'rebuildm.exe' to rebuild master from CD. Failed.Well, I'm a fish in the hot water, I guess I have to re-install SQlserver7, so I did,7. Remove SQLserver7 from add/remove program, I selected 'not remove the *.dll', that might be a big mistake!!8. Remove SQLserver entry from registry. There'are some I can't remove9. Re-install SQLserver7, failed at the very end. Can't start service. Could someone tell me which steps I was wrong? Thanks a lot! " |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|
|
|
Can't reinstall SQLserver7 on a new server after restoring master DB 