December 22, 2011 at 2:18 am
how to restore master database?
December 22, 2011 at 2:27 am
Find below link for your question
http://http://msdn.microsoft.com/en-us/library/ms190679.aspx/
http://qa.sqlservercentral.com/Forums/Topic490956-357-1.aspx
December 22, 2011 at 3:44 am
Dhirju (12/22/2011)
how to restore master database?
Is it for knowledge update or you are having a serious issues with Master DB?
December 22, 2011 at 8:03 am
Dhirju (12/22/2011)
how to restore master database?
Ensure you restore the model and MSDB too.
Do you have any experience of starting\operating SQL Server in single user mode?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2011 at 10:06 am
A little tip: I create a file copy of the master database. If the master database should be so corrupt that SQL Server cannot start, I use this file copy backup instead of rebuilding the system databases. This is only for the rare cases where SQL Server won't start, and If used I still need to restore the latest backup.
December 22, 2011 at 10:31 am
okbangas (12/22/2011)
A little tip: I create a file copy of the master database. If the master database should be so corrupt that SQL Server cannot start, I use this file copy backup instead of rebuilding the system databases. This is only for the rare cases where SQL Server won't start, and If used I still need to restore the latest backup.
If you do that regularly, that can work. Otherwise, if you make updates to master (new logins), then this doesn't help.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 22, 2011 at 11:11 am
Steve Jones - SSC Editor (12/22/2011)
okbangas (12/22/2011)
A little tip: I create a file copy of the master database. If the master database should be so corrupt that SQL Server cannot start, I use this file copy backup instead of rebuilding the system databases. This is only for the rare cases where SQL Server won't start, and If used I still need to restore the latest backup.If you do that regularly, that can work. Otherwise, if you make updates to master (new logins), then this doesn't help.
It can help a bit.
Replace the damaged file with the older one, then start SQL in single user mode and restore the backup of master. Still easier than rebuilding the system DBs (which does all of them) and then restoring backups.
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
December 22, 2011 at 1:50 pm
p.s. And do the same thing with Model. It's an absolute pain if that one gets damaged, I haven't yet found a way to restore that without first rebuilding all the system databases otherwise. (single user mode requires recovering TempDB, which fails if model is damaged which causes SQL to shut down. A traceflag lets SQL start without recovering TempDB, but starting a restore recovers TempDB, which requires model, which causes SQL to shut down if it's damaged. Catch-22 anyone?)
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
December 23, 2011 at 2:04 am
Dev. it is only for my knowledge.
December 23, 2011 at 2:17 am
Then see the links that Salum posted
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
December 23, 2011 at 4:36 am
Dhirju (12/23/2011)
Dev. it is only for my knowledge.
Good to know that you are preparing yourself for worst database scenarios (DBA’s nightmares :w00t:).
Best of Luck!
December 23, 2011 at 4:45 am
Thanks 😀
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply