Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Default size of blank database

Author  Topic 

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2009-09-27 : 10:09:46
Hi All..

What should be default size of blank database or mdf and ldf files if i created blank database???

T.I.A

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-09-27 : 12:37:28
Unless you specify otherwise, the data and log files would use the sizes defined by the model database. You can resize model's files to be whatever default you choose.
Go to Top of Page
   

- Advertisement -