If the master database is not available (say, due to corruption or a disaster that wipes away the disk where the master database is kept) then your instance of SQL Server cannot function. The master database stores metadata about the instance of SQL Server: things like server logins, databases and database file locations, server configuration details, and linked server definitions are all stored inside of the master database.
But when the time comes (in the middle of the night, of course) you will want to be prepared. With over 180 instances of SQL Server in our care I believe that is a large enough sample size making it safe to assume that restoring master is not something you will find yourself needing to do often. In my seven years as a production DBA I can count on one hand the number of times I have needed to restore the master database as a result of a disaster.
0 kommentar(er)
