November 27, 2012 at 11:38 pm
Hi Guys
Situation: SQL 2008 Master DB is corrupt, instance won't start and I have backups of the master database
I'm referencing the following article:
http://www.sqlservercentral.com/articles/Rebuilding+system+databases/87156/
It seems that when your Master database is corrupt, the rebuild process recreates all your system databases, is this necessary if just your Master is broken?
Is there another way to get around this situation?
Thanks
November 28, 2012 at 12:47 am
Yes, it is necessary. Rebuild the system databases, start SQL, restore the backups of the system DBs.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2012 at 12:51 am
GilaMonster (11/28/2012)
Yes, it is necessary. Rebuild the system databases, start SQL, restore the backups of the system DBs.
Could this possibly work:
>> Restore the Master database to another SQL Instance
>> Replace with mdf and ldf of the corrupted master with a copy of the restored master files
November 28, 2012 at 1:26 am
I would not recommend restoring master to other servers. Not least because you overwrite that server's master DB which you then have to go and restore from its backups later.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2012 at 1:32 am
GilaMonster (11/28/2012)
I would not recommend restoring master to other servers. Not least because you overwrite that server's master DB which you then have to go and restore from its backups later.
And restoring it as a different database?
November 28, 2012 at 2:37 am
SQLSACT (11/28/2012)
GilaMonster (11/28/2012)
Yes, it is necessary. Rebuild the system databases, start SQL, restore the backups of the system DBs.Could this possibly work:
>> Restore the Master database to another SQL Instance
>> Replace with mdf and ldf of the corrupted master with a copy of the restored master files
I have previously restored the master as a user database and detached it, renamed the disk files back and then plugged them into the corrupted instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2012 at 2:41 am
Perry Whittle (11/28/2012)
SQLSACT (11/28/2012)
GilaMonster (11/28/2012)
Yes, it is necessary. Rebuild the system databases, start SQL, restore the backups of the system DBs.Could this possibly work:
>> Restore the Master database to another SQL Instance
>> Replace with mdf and ldf of the corrupted master with a copy of the restored master files
I have previously restored the master as a user database and detached it, renamed the disk files back and then plugged them into the corrupted instance
Is it just me or does this seem like a much simpler approach?
Are there any downsides to this method?
November 28, 2012 at 4:11 am
For the instance to start it needs to have a master db present, i use the tact above and then make sure to restore a full system backup set once the instance is accessible
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 28, 2012 at 6:58 am
it won't help this time I know, but I always keep flat files copies of the system databases (I take a copy at each upgrade), then these can just be slid into place in the event of a corruption.
---------------------------------------------------------------------
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply