• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

CREATE DATABASE Branch - LOG ON MAXSIZE = UNLIMITED,

This option is recommended? to use  MAXSIZE = UNLIMITED,  for creating LOG file?
0
enrique_aeo
Asked:
enrique_aeo
  • 2
2 Solutions
 
Kent DyerIT Security Analyst SeniorCommented:
There is a limitation of this..

http://connect.microsoft.com/SQLServer/feedback/details/175549/database-file-maxsize

The max size for log files is 2TB = 2048GB. If you look at the original output for the maxsizes of the log files in you will see that both report the same size = 2TB

From BOL

UNLIMITED
Specifies that the file grows until the disk is full. In SQL Server 2005, a log file specified with unlimited growth has a maximum size of 2 TB.
Thanks.

HTH,

Kent
0
 
enrique_aeoAuthor Commented:
is a good practice?
0
 
Kent DyerIT Security Analyst SeniorCommented:
There are different schools of thought for sizing database and setting log growth.  It depends on what you want to do and what environmental resources you have available and are not limited to: drives, servers, SAN, NAS, etc.  For example, if you want to grow your database by 1MB at a time, it would do database re-sizing more frequently than say 10% of the overall database size.  The trade-off for the 10% growth is that there would be more time taken in the re-size process and the time to do this can increase over time.  The impact to the customer (end-user experience) is usually quite minimal.  The other thing to keep in mind, with an enterprise database, it is good practice to keep your logs on separate drive spindles (yes, even on a SAN) for optimum database performance.

HTH,

Kent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now