Purpose of Default Databases In MSSqlServer

Purpose of Default Databases of Master Databases

1) Master Database :- It is Compulsory .If we delete this database then Sql Server Will not Start. It contain all entries like which database is stored at which location, login account info, link server info, instance info etc.

2) Model Database :- It is Common Templates for all databases. Database of size if not mentioned , then all such as properties or setting are stored in model Database and By Default these are setting are used by Database(Like Size of Transaction log File etc).

3) MSDB Database :- It is used for Scheduling.

4) Tempdb Database :- Used for temporary storage.Once the Service of SQL is stopped or Reset then all data in Tempdb Database Destroy or deleted.

5) Resource Database :- All System objects are stored in resource database physically.Logically these are present in all databases and these can be accessed by sys.schema

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s