asked
Rebuilding or Recovering the Master database?
Hi, Rebuilding and recovering the database sounds both are different from each other but it does not make sense to me,i am little confused when i read, Is rebuilding and recovering different individual solutions to recover the master database or both of them are part of the restoring database process? up to my knowledge restoring means recreating (with a backup file) , recovering means database is transforming or changing to different state but How rebuilding is different from restoring?
You are right that they are different activities. A "rebuild" of master requires that you run the setup.exe program. It resets the master database to its original unpatched RTM state. You need to apply service packs and/or hot fixes to get it back up to the patch level it was at before the rebuild - [
http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx][1] A "restore" of master (assuming the "recover" in the question is synonymous with "restore") is a database restore of the master database, with some special steps that wouldn't apply to user databases. This leaves the master database in the state it was in at the time of the backup (the same patch level and logins etc.) - [
http://msdn.microsoft.com/en-us/library/ms190679.aspx][2] [1]:
http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx [2]:
http://msdn.microsoft.com/en-us/library/ms190679.aspx
15 People are following this question.
