THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Rebuild master in SQL Server 2008

This blog has moved! You can find this content at the following new location:

Published Friday, August 29, 2008 9:18 PM by TiborKaraszi



Tibor Karaszi said:

All my attempts so far to rebuild the system databases in 2008 R2 has failed. I first tried to run setup

June 3, 2010 7:39 AM

Abhishek Dwivedi said:

Follow the steps below to rebuild the Master Database.

1. From a command prompt window change to the following directory:

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

2. Next paste the following into the command prompt window and press “Enter”:

Setup.Exe /Action=RebuildDatabase /InstanceName=MSSQLSERVER /SqlSysAdminAccounts=Admin

The instance name will be MSSQLSERVER unless you are using a named instance and in that case change MSSQLSERVER to your instance name and the SqlSysAdminAccounts will be an account with SysAdmin rights then and press “Enter” again.

September 15, 2011 12:02 PM

rajesh said:

if i use 2012 version how can i troubleshoot this issue

September 24, 2013 5:25 AM
New Comments to this post are disabled
Privacy Statement