Hi,
I wanted to find out if there is a way to fix Master DB. I ran DBCC and it
shows some allocation errors. I understand I can run Repaid_Allow_Data_Loss
with other databases but not with Master, Is this correct? Is there another
way to fix the DB rather than having to restore it?
Thank you.1. change sql server to single mode
2.stop sql server service
3.restore database
: RESTORE DATABASE master FROM DISK='C:\SQLDATA\...\...'
cheers|||Thank you but all my backups have the same errors as well so I need fix it
somehow.
"jongwoo" <jongwoo@.discussions.microsoft.com> wrote in message
news:DE879B08-EDAC-4B05-BDFA-0CBAFC9E5F28@.microsoft.com...
> 1. change sql server to single mode
> 2.stop sql server service
> 3.restore database
> : RESTORE DATABASE master FROM DISK='C:\SQLDATA\...\...'
> cheers|||If you give as much error message info as possible, we should be more able to
help out.
No comments:
Post a Comment