Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the default size of SQL Server Database?

user-image
Question ajoutée par Krishna s valsan , It support , Insight export and placement services
Date de publication: 2018/01/03
Muhammad Aamir Majeed
par Muhammad Aamir Majeed , Asstt. Computer Programmer , Sitara Energy Ltd

I am not sure but i think it will be upto 8MB 

aravind gajula gajula
par aravind gajula gajula , Team Leader

DEFAULT SIZE OF INSATALLATION OF SQL SERVER IS

MDF=3MB

LDF=1MB

The default size of the user database is based on system database model.

When we create a new user database it is modeled after model database and created with same settings and properties. If your model database has large mdf or ldf file the same can be automatically replicated when a new user database is created. This was the actual case in the scenario mentioned earlier. On a separate note, with the default installation of SQL Server the mdf file of model database is 3 MB and ldf is about 1 MB

Muhammad Shahid Farooq
par Muhammad Shahid Farooq , Software Engineer, System Integrator , ForeVision Business Solutions

Default size of SQL Server database depends upon the properties and settings you choosen at the time of installation.

Mamoun Aljaber
par Mamoun Aljaber , Unit head of Data Center & IT Support , YIACO MEDICAL co.

MDf File 3 MB and ldf 1 MB 

ISMAIL ESSABR
par ISMAIL ESSABR , Gérant , SINKI GN

with the default installation of SQL Server the mdf file of model database is 3 MB

Santosh Goud Mallagoni
par Santosh Goud Mallagoni , Software Developer , Archents IT India Private Limited

On a separate note, with the default installation of SQL Server the mdf file of model database is 3 MB and ldf is about 1 MB.

Sakher Al-Sheyyab
par Sakher Al-Sheyyab , MIS Coordinator , Sakher T. Al-Sheyyab

200MB is the default size of SQL Server Database

Majid Muhammad
par Majid Muhammad , Manager DBA , FFHO

Data size = 2MB

Log size = 1MB

Majed Aiyash
par Majed Aiyash , technical support engineer , Ultimate solutions

3 MB by default /size of model database

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?