Articles → SQL SERVER → Rebuild System Databases In SQL Server 2008

Rebuild System Databases In SQL Server 2008

In this article, we will rebuild system databases.

Software Requirement

Before you start reading this tutorial, you should make sure that SQL server 2008 is installed on your machine.

Prerequisite Knowledge

Before you go ahead, it is required that you should know: -

What are system databases?
What is the purpose of the system databases?

What Does Rebuild Do?

Rebuild sets the system databases to its default state. For example, if you have added 3 databases then after rebuild all three databases gets deleted. So, it is a good practice to take back up before rebuilding system databases.

Scenarios Of Rebuilding Database

In the real time scenarios, system databases are rebuilt when they got corrupted.

Steps

Open command prompt
Go to the following path

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

If you are using SQL Server instance then go to the following path

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap

Execute following query

setup.exe  /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=sqlexpress2k8r2  /SQLSYSADMINACCOUNTS= my_domain\admin_user_name /SAPWD=login_password

In the above code: -

Option	Description
/QUIET	It means that setup is run without any user interface
/ACTION=REBUILDDATABASE	It means system databases are recreated
/INSTANCENAME=sqlexpress2k8r2	specifies the instance name of database
SQLSYSADMINACCOUNTS= my_domain\admin_user_name	specifies the domain name and admin user name of the system
/SAPWD=login_password	specifies the login password of the admin user

Log In Summary.Txt File

"Summary.txt" is the log file which stored at "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log location". If the rebuild executes successfully the log is stored in this file in this way.

Overall summary:

  Final result:                  Passed
  Exit code (Decimal):      0
  Exit message:               Passed
  Start time:                    2012-06-29 17:20:19
  End time:                      2012-06-29 17:23:37
  Requested action:          RebuildDatabase

Posted By -	Karan Gupta

Posted On -	Tuesday, July 3, 2012

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**