Saturday, February 25, 2012

restore master problem

When i try to restore master db with
sqlservr -c -m -T4022
ISQL -E , restore database master from device='d:\dump\masterdump.dat'
restore fail with message
Error: 3151, Severity: 21, State: 0.
Error: 9001, Severity: 21, State: 1.
and sqlserver terminated..
I have try this.
1. backup a new masterdump from other sqlserver b and and restore to server
a .. same problem
2. take this masterdump from server b and restore to other server, sucessful.
3. backup master from sqlserver(a) and restore to sqlserver(a) succesful.
i using sqlserver sp3
win2003 standard edition..
any suggestion?Hi,
Did you try rebuilding the master with rebuildm utlility and then try to
restore again?
--
Danijel Novak
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:3184264F-DC6F-4A12-B8B9-E7F8C508B14A@.microsoft.com...
> When i try to restore master db with
> sqlservr -c -m -T4022
> ISQL -E , restore database master from device='d:\dump\masterdump.dat'
> restore fail with message
> Error: 3151, Severity: 21, State: 0.
> Error: 9001, Severity: 21, State: 1.
> and sqlserver terminated..
> I have try this.
> 1. backup a new masterdump from other sqlserver b and and restore to
> server
> a .. same problem
> 2. take this masterdump from server b and restore to other server,
> sucessful.
> 3. backup master from sqlserver(a) and restore to sqlserver(a) succesful.
> i using sqlserver sp3
> win2003 standard edition..
> any suggestion?
>

No comments:

Post a Comment