Re: restore master

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/11/04 

Date: Sun, 11 Jul 2004 10:00:45 +0530

Hi,

Login can be copied from source server to destination server. But Master
database stores the other details like:-

1. Configuration parameters
2. Server Names ,..

So after creating the logins you have to manually sync. that as well.

See the below link to transfer logins from one server to another server with
the same password.

http://www.databasejournal.com/features/mssql/article.php/2228611

Thanks
Hari
MCDBA

"RM" <m_r1824@yahoo.co.uk> wrote in message
news:opsayeffn6hqligo@msnews.microsoft.com...
> thanks,
> but can I just script my login definition and
> relation between them and he users and run it in destination
> instead of restoring master database?
>
>
>
> On Sat, 10 Jul 2004 05:44:31 -0700, Thirumal <treddym@yahoo.nospam.com>
> wrote:
>
> > Hi,
> >
> > 1]To restore master database u need to start SQL service
> > in single user mode. navigate to appropriate SQL Server
> > directory and issue the below at command prompt.
> >
> > sqlservr.exe -c -m
> >
> > 2]It is not recommended to drop guest login from master
> > and tempdb.
> >
> > When users login into SQL Server, by default they have
> > access to 'master' database. SQL Server internally uses
> > guest for access , who has less permissions, so need not
> > worry. If u drop 'guest' (assuming that it is allowed) you
> > must be a 'sa' to access the master all the time.
> >
> >
> > With Regards
> >
> > Thirumal
> >
> > www.thirumal.com
> >> -----Original Message-----
> >> Hi
> >>
> >> I want to restore master db(first) in another server
> >> which has sql server 2000 before restoring user dbs,
> >> to locate login and ....
> >> but following error happended,what's wrong?
> >> "resore database must be used in single user mode
> >> when restoring master db"
> >> and I found there's only one login name called "sa"
> >> as system administrator,
> >> but when I expand the user branch in master database
> >> I found "sa" and "guest" there,
> >> and when I tried to drop guest following error happened
> > too:
> >>
> >> "cannot drop the guest user from master or tempdb"
> >>
> >> 1 - does not restoring master related to guest?
> >> 2 - anyway,how can I drop guest?
> >>
> >> any help would be greatly thanked.
> >> .
> >>
>

Relevant Pages

  • Permission to view system tables in master database
    ... I am trying to avoid the "Permission denied" error message when a proc tries ... Creating a proc that can view server state ... Master DB ... Create user for special login in the User DB ...
    (microsoft.public.sqlserver.security)
  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)
  • RE: OWA 2003 with ISA 2004
    ... OWA externally. ... i can login by any user. ... 825763 How to configure Internet access in Windows Small Business Server ... g. Reproduce this issue and send the logs to me. ...
    (microsoft.public.windows.server.sbs)
  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... there are a bunch of logins for Website Accounts created by the ... The login accounts are for web sites that are on the ... Server management is ... right under Network Connections there were 3 ...
    (microsoft.public.windows.server.networking)
  • Re: IIS 6.0 FTP
    ... Server port: 21. ... I doubt IIS FTP has such feature. ... next, general 530 error indicating login failed, that could due to ... clients are using an order entry program created in Microsoft access. ...
    (microsoft.public.inetserver.iis.ftp)