Explain how to rebuild Master Database


Interview questions

SQL Server - How to rebuild Master Database.

Next>>         SQL Server tutorial  

SQL Server - How to rebuild Master Database. - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

Explain how to rebuild Master Database.

Steps to rebuild master database:

  • Shut down the SQL Server instance and run Rebuildm.exe.
  • In Rebuild Master dialog box, choose Browse.
  • Select \Data folder from where SQL Server was installed and click OK
  • Click Settings and in Collation Settings, change settings for master database and then click OK
  • Click Rebuild on Rebuild Master dialog box.

SQL Server - How to rebuild Master Database. - May 05, 2009 at 22:00 PM by Rajmeet Ghai

Explain how to rebuild Master Database.

The Master database can be rebuilt using the following steps:

  • The server should be shut down and Rebuildm.exe should be run.
  • Browse for \Data folder on the SQL Server 2000 compact disc or in the shared network directory and click OK.
  • Using the collation settings options, master database and all other databases should be verified.
  • Using the rebuild master rebuild can be clicked to rebuild the database.

SQL Server - How to rebuild Master Database. - June 21, 2009 at 09:00 AM by Amit Satpute

To rebuild the master database

1. Shutdown SQL Server and then run Rebuildm.exe located in the Program Files\Microsoft SQL Server\80\Tools\Binn directory.

2. In the Rebuild Master dialog box, browse and select the \Data folder on the SQL Server 2000 compact disc or in the shared network directory from which SQL Server 2000 was installed.

3. In the Collation Settings dialog box, verify the settings used for the masterdatabase and all other databases.

4. The default collation settings shown may not match the collation selected during setup due to which that can then need to be changed.

5. The same settings may be used during setup or new collation settings may be selected.

6. Then Rebuild through the Rebuild Master dialog box to start the process.

7. The Rebuild Master utility reinstalls the master database.


Also read

How do you restore the master database on a SQL Server cluster?

Restoring a master database on a SQL server cluster is required in case of a disaster when the previous backup is required. Ideally, restarting the server in single user mode can resolve this problem...........

SQL Server system database

Master Database MSDB Database, TEMPDB Database, Model Database.........

Describe in brief system database.

Answer - Master database is system database. It contains information about server’s configuration. It is a very important database and important to backup Master.....

Define transaction and transaction isolation levels.

Answer - A transaction is a set of operations that works as a single unit. The ransactions can be categorized into explicit, autocommit, and implicit....

SQL Server Optimization Tips

Answer - Restricting query result means return of required rows instead of all rows of the table. This helps in reducing network traffic......

Write your comment - Share Knowledge and Experience


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring