I want to move sql server from server A to server B.
1. path of system database in server A and server B in diffrent
2. I backup master.dat from server A to restore to server B and to something
alter and it work fine.
3. I create another copy of master from server A and try to restore to
server, fail to restore.
restore fail with message
Error: 3151, Severity: 21, State: 0.
Error: 9001, Severity: 21, State: 1.
4. I have to rebuild the master in server B.. and then restore master.
Is this normal.? I mean need to rebuild the master in server B..
How many user databases / Logins do you need to move ..?
If it's a small number it may be easier for you to simply install SQL Server
on Server B, restore the user database and create the logins manually.
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:DFB62E1F-E079-4CAD-ADBF-2A6AF6BCD820@.microsoft.com...
> I want to move sql server from server A to server B.
> 1. path of system database in server A and server B in diffrent
> 2. I backup master.dat from server A to restore to server B and to
something
> alter and it work fine.
> 3. I create another copy of master from server A and try to restore to
> server, fail to restore.
> restore fail with message
> Error: 3151, Severity: 21, State: 0.
> Error: 9001, Severity: 21, State: 1.
> 4. I have to rebuild the master in server B.. and then restore master.
> Is this normal.? I mean need to rebuild the master in server B..
|||more then 15 db, more then 50 users..
"John Smith" wrote:
> How many user databases / Logins do you need to move ..?
> If it's a small number it may be easier for you to simply install SQL Server
> on Server B, restore the user database and create the logins manually.
>
> "soonyu" <soonyu@.discussions.microsoft.com> wrote in message
> news:DFB62E1F-E079-4CAD-ADBF-2A6AF6BCD820@.microsoft.com...
> something
>
>
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment