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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



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

Leave a Comment

Privacy Statement