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
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...........
Master Database MSDB Database, TEMPDB Database, Model 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.....
Answer - A transaction is a set of
operations that works as a single unit. The ransactions can be categorized into
explicit, autocommit, and implicit....
Answer - Restricting query result means
return of required rows instead of all rows of the table. This helps in
reducing network traffic......
|
