|
Home > Archive > MS SQL Server > February 2006 > restore master database: no restart
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Uri Dimant 2006-02-06, 3:23 am |
| http://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@microso
ft.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 ----- Move
> Databases between computers running by sql server
>
>
>
>
>
>
>
>
>
>
>
>
>
> "jouj" <jouj@discussions.microsoft.com> wrote in message
> news:82161742-1B9D-45C5-ABFF- BDF5E384148B@microso
ft.com...
>
>
>
|
|
|
|
|