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?
CREATE DATABASE Sales ON (
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