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

Rebuild System Databases In SQL Server 2008

Software Requirement

Prerequisite Knowledge

  1. What are system databases?
  2. What is the purpose of the system databases?

What Does Rebuild Do?

Scenarios Of Rebuilding Database


  1. Open command prompt
  2. Go to the following path
  3. C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2
  4. If you are using SQL Server instance then go to the following path
  5. C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap
  6. Execute following query
  7. setup.exe  /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=sqlexpress2k8r2  /SQLSYSADMINACCOUNTS= my_domain\admin_user_name /SAPWD=login_password

/QUIETIt means that setup is run without any user interface
/ACTION=REBUILDDATABASEIt means system databases are recreated
/INSTANCENAME=sqlexpress2k8r2specifies the instance name of database
SQLSYSADMINACCOUNTS= my_domain\admin_user_namespecifies the domain name and admin user name of the system
/SAPWD=login_passwordspecifies the login password of the admin user

Log In Summary.Txt File

  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


Your Email Id  
Query/FeedbackCharacters remaining 250