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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2001-12-22 : 17:06:31
|
| Hi there,I wanted to post this question to see if anyone else had a similar experience. I have tried several times now to restore my master db in SQL SERVER 7.0. I have tried it at home on my development server and also at work a few times (to prepare me for that BIG DAY when I need to do it) but each time I fail miserably!. I start the SQL service in single user mode (by adding the -m to the start up parameters in EM) which allows me to restore the master but then I get some connectionFailed error and the sql service just starts and stops in a vicious loop!The problem arose again on Friday when we installed SQL SERVER SP3 on WIN2k and upon reboot got some registry errors - ended up having to re-install WIN2k and SQL and restore all my databases from backups. When I tried to restore the MASTER it did this looping thing again and I had to reinstall SQL again and just restore all user info etc manually.So I am yet to have successfully restored a MASTER db! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-22 : 19:32:41
|
| Must admit that if I hve a problem with master I always re-install sql server - of course we all have a record of the current state of the master database don't we.I have done it in the past but maybe not for v7+.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
restore the MASTER db