Wednesday, April 27, 2011

Master database:

It is a must run DB. It contains all server related information like server version, user/login details, configuration settings, linked server details, instance information and etc.

In SQL server 2000 all the system databases are stored in master database directly but in SQL Server 2k5/2k8 we have resource database where the actual tables are stored and the sys schema of the system tables are stored in master database. So in SQL Server 2 k 5/2 k 8 master databases will have schemas and stored procedures of the actual system objects.

The maximum size till master database log file can grow is 2 terabytes (SQL Server 2008) and for data file there are no such restriction, it grows till the disk is full. ‘sys.databases’ view can be used to get information of master database.

Complete list of Do’s and Don’ts:

Rebuilding:

For rebuilding system databases in SQL Server 2005 version we have to use ‘setup.exe’ and to perform this we need to insert the installation DVD.

For rebuilding system databases in SQL Server 2008 version we have to use ‘setup.exe’. This exe can be found in the directory where we installed sql server ‘100\Setup Bootstrap\Release’ location. To perform this no need to insert the installation DVD it automatically takes the databases from BINN/templates folder.

Rebuilding system databases in SQL Server 2008:



For rebuilding master database in SQL Server 2000:

While rebuild master database in this version we can use ‘rebuildm.exe’.   This opens up the ‘Rebuild Master’ window where we can set up the options required.

Reference:

No comments:

Post a Comment