asked
system database corruption
I am looking for the process of the following situations if system database corrupted in SQLSERVER 2008 to 2014 versions. -> Master,model,msdb and temp db corrupted how we will recover them. -> We don't have backup of the system databases and all MDF and LDF files are also corrupted then how we can recover them. I just want to know all the scenarios if the system databases facing any problem how we can recover them and how many ways are there to recover?
With no backups of master/msdb, your pretty much screwed unless you have scripts to create logins, linked servers, jobs, basically anything thats server side. Assuming you havn't made changes to model, you could just put in a copy of model from another server at the same level as the corrupted server. EG If you have 2, 2008 R2 boxes at the same SP level, just copy a working model and replace your old model. TempDB is recreated at service startup so if you have a working model you will get a working TempDB Other than that, the only way to get back master/msdb/model/tempdb is to rebuild the system databases via the installer. But as stated you will loose any server side configuration you have.
19 People are following this question.
