Saturday 13 July 2013

Default sizes for databases in Sql Server

Master database – Stores system files – 11MB

Model database – Template for all databases – 0.75MB
Temp database – Stores temporary objects – 8MB
Msdb database – Used by SQL server agents for scheduling alerts and jobs and recording operators- 12MB
The min. value for DB size is 512KB
The default size for DB is 1MB.

No comments:

Post a Comment

C# LINQ Joins With SQL

There are  Different Types of SQL Joins  which are used to query data from more than one database tables. In this article, you will learn a...