Aug 24, 2009

Default Size of Log File

What will happen if you create a database without the specification of log file?  Yes, SQL Server will create the log file in its default location. What about the size? Will SQL Server create with the size of the log file in model database?


NAME = Sales_data,
FILENAME = 'D:\SQLData\SQL2k8\DATA\Sales.mdf',
SIZE = 60)

Interestingly,  SQL Server will create the log file with 25% of the data file. If you specify multiple data files,  log file size is determined by 25% of the sum of all data files

Are you getting a different size?

No comments:

Post a Comment