restore master database: no restart

Dear all,
I'm working on MS SQL 2000 SP3.
I'm trying to switch to a new server.
When I tried to restore the master database, the server wouldn't re-start.
so I tried another way, that is to restore user-databases and transfer the
users-accounts (DTS) but it seems that the users cannot connect to the new
server.(no permissions).
I prefere to have a success "restore master database".
what am I missing?
Thanks in advance
jouj
http://support.microsoft.com/default...n-us;Q314546#9 -- Move
Databases between computers running by sql server
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000 SP3.
> I'm trying to switch to a new server.
> When I tried to restore the master database, the server wouldn't re-start.
> so I tried another way, that is to restore user-databases and transfer the
> users-accounts (DTS) but it seems that the users cannot connect to the new
> server.(no permissions).
> I prefere to have a success "restore master database".
> what am I missing?
> Thanks in advance
> jouj
>
|||Many thanks
jouj
"Uri Dimant" wrote:

> http://support.microsoft.com/default...n-us;Q314546#9 -- Move
> Databases between computers running by sql server
>
>
>
>
>
>
> "jouj" <jouj@.discussions.microsoft.com> wrote in message
> news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
>
>

restore master database: no restart

Dear all,
I'm working on MS SQL 2000 SP3.
I'm trying to switch to a new server.
When I tried to restore the master database, the server wouldn't re-start.
so I tried another way, that is to restore user-databases and transfer the
users-accounts (DTS) but it seems that the users cannot connect to the new
server.(no permissions).
I prefere to have a success "restore master database".
what am I missing'
Thanks in advance
joujhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#9 -- Move
Databases between computers running by sql server
"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000 SP3.
> I'm trying to switch to a new server.
> When I tried to restore the master database, the server wouldn't re-start.
> so I tried another way, that is to restore user-databases and transfer the
> users-accounts (DTS) but it seems that the users cannot connect to the new
> server.(no permissions).
> I prefere to have a success "restore master database".
> what am I missing'
> Thanks in advance
> jouj
>|||Many thanks
jouj
"Uri Dimant" wrote:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#9 -- Move
> Databases between computers running by sql server
>
>
>
>
>
>
> "jouj" <jouj@.discussions.microsoft.com> wrote in message
> news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
> > Dear all,
> > I'm working on MS SQL 2000 SP3.
> > I'm trying to switch to a new server.
> > When I tried to restore the master database, the server wouldn't re-start.
> >
> > so I tried another way, that is to restore user-databases and transfer the
> > users-accounts (DTS) but it seems that the users cannot connect to the new
> > server.(no permissions).
> >
> > I prefere to have a success "restore master database".
> >
> > what am I missing'
> >
> > Thanks in advance
> > jouj
> >
> >
>
>

restore master database: no restart

Dear all,
I'm working on MS SQL 2000 SP3.
I'm trying to switch to a new server.
When I tried to restore the master database, the server wouldn't re-start.
so I tried another way, that is to restore user-databases and transfer the
users-accounts (DTS) but it seems that the users cannot connect to the new
server.(no permissions).
I prefere to have a success "restore master database".
what am I missing'
Thanks in advance
joujhttp://support.microsoft.com/defaul...en-us;Q314546#9 -- Move
Databases between computers running by sql server

"jouj" <jouj@.discussions.microsoft.com> wrote in message
news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
> Dear all,
> I'm working on MS SQL 2000 SP3.
> I'm trying to switch to a new server.
> When I tried to restore the master database, the server wouldn't re-start.
> so I tried another way, that is to restore user-databases and transfer the
> users-accounts (DTS) but it seems that the users cannot connect to the new
> server.(no permissions).
> I prefere to have a success "restore master database".
> what am I missing'
> Thanks in advance
> jouj
>|||Many thanks
jouj
"Uri Dimant" wrote:

> http://support.microsoft.com/defaul...en-us;Q314546#9 -- Mo
ve
> Databases between computers running by sql server
>
>
>
>
>
>
> "jouj" <jouj@.discussions.microsoft.com> wrote in message
> news:82161742-1B9D-45C5-ABFF-BDF5E384148B@.microsoft.com...
>
>

Restore master database from backup

I wish to restore master database which was located on "e:" on my server.
the restored copy is residing on "f:"
when i restore the backup and restart, the server does not start.

is there any way to avoid this and perform the restoration succesfully.
or the process followed by me is wrong/incomplete.

do let me know...TIAtry this link

http://www.dbarecovery.com/restoremasterdb.html