My actual System Databases are located in DATA folder as shown below I repeat, these are Just templates which SQL Server will create behind the scenes during Installation Process. These are not the actual system database files…. Let me show you what I’m talking about….You can see the templates folder which SQL Server created while initial Installation of this Instance on my machine. (This is the one of the main Reasons,you should place your SQL Binaries and actual System Databases on completely separate Physical Drives. 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)
