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 |
|
gercr
Yak Posting Veteran
53 Posts |
 Posted - 2002-10-11 : 19:58:07
|
| Hi Recently I run the rebuild utility to change the collation of all my databases on the server, the rebuild was do it with no problem, but all databases and logins was deleted.how I can restore master from a old backup (maded before run rebuild utility)??? |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-12 : 12:17:29
|
| That's exactly what rebuildm does, it recreastes master from the original media - thus any logins,databases,linked servers etc are lost. What you should do is detach your databases, script your logins,linked servers etc to file and then run rebuildm. To get back to where you started then you need to restore the master database.1) Stop all SQL Services2) Open a command prompt and cd to the directory containing sqlservr.exe3) Run sqlservr.exe -c -m from the command prompt4) Execute RESTORE DATABASE master from DISK='backupfile'5) Use Ctrl-C to stop SQL Server6) Start SQL from SQL Service Manager7) Verify the restore was successfullHTHJasper Smith |
 |
|
|
|
|
|
RESTORE MASTER FROM BKUP