Go back to the Sql Server Configuration Manager and restart the SQL services. Ctrl-C to stop SQL server in single user mode, then close the command window. Restart the SQL Server Services in regular mode End the command shell you started earlier.
REBUILD DATABASE IN MICROSOFT ENTOURAGE 2008 HOW TO
Please refere to Books on Line for compelete details on how to use Setup.exe.
To rebuild, use the following command “start /wait setup.exe /qn INSTANCENAME= REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=”.
To rebuild the master database you need to use the setup.exe found on the SQL 2005 installation media. Rebuild the system databases In SQL 2005, the rebuildm.exe program is nto supported. Run “sqlserver.exe -m” to start the sql server from single user mode. Start the SQL server in Single User Mode Open a command window and navigate to the folder where Sqlservr.exe resides (generally installdrive:\Program Files\Microsoft Sql Server\MSSQL.1\MSSQL\Binn). The services are stopped, you can proceed to Step 2. Right Click on each service listed and stop the service. From this console you can manage the various SQL server services running on the machine. There are a few ways to do this, but the easiest way would be to use the SQL Configuration Manager (Start->All Programs->Microsoft Sql Server 2005->Configuration Tools->Sql Server Configuration Manager). Put SQL Server into Single User Mode The first thing you will want to do is stop the SQL Sever Sevicer (sqlservr.exe) and the associated services (Agent, Full Text, Etc). Hello Bijoy, Here is how you rebuild master in SQL 2005.
0 kommentar(er)
