![]() ![]() ![]() Setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME= /SQLSYSADMINACCOUNTS= Run setup.exe with the following syntax from a Windows command prompt:įor Windows Authentication Mode use this syntax: Find setup.exe either from your original media or the “local” setup.exe as found in the directory where you have installed SQL Server in the 100Setup BootStrapRelease directory. ![]() Here are the details about how to use this syntax: The syntax for using setup.exe to rebuild the system databases is as follows: I’ll outline how to use this command line option in this blog post. SQL Server 2008 utilizes the same process to rebuild the system databases however the command line switches have changed some and the process behind the scenes to rebuild the system databases (master, model, and msdb) is also a bit different.Ĭurrently the SQL Server 2008 Books Online only mention an option for setup called /REBUILDDATABSES (See this ms144259). This involved running the setup.exe program with command line switches. In SQL Server 2005, a new method of rebuilding the system databases was introduced known as “rebuild master”. ![]()
0 Comments
Leave a Reply. |