Register now or log in to join your professional community.
I am not sure but i think it will be upto 8MB
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
Default size of SQL Server database depends upon the properties and settings you choosen at the time of installation.
MDf File 3 MB and ldf 1 MB
with the default installation of SQL Server the mdf file of model database is 3 MB
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.
200MB is the default size of SQL Server Database
Data size = 2MB
Log size = 1MB
3 MB by default /size of model database
