Starting SQL Server 2008 it’ll rebuild based upon the TEMPLATES which it creates in your BINN Directory. Those days are gone.That was the case with SQL Server 2005 and earlier. There’s a misconception that we need the Actual SQL Server media and it’s mandatory to rebuild your Master.
Rebuilding Master will actually create brand new System databases from scratch as if you just Installed your SQL Server. Have you ever been in a situation where you lost the complete Drive where your System Databases are residing and even SAN Admins were not able to bring the Drive back? Fortunately I’ve never been in that situation:) What would be our available options if that disaster strikes? In this scenario restoring System Databases won’t work because SQL Server Service itself is completely down and your System Databases mdf and ldf files are gone!!.So what should we do? REBUILD YOUR MASTER.
0 kommentar(er)
