Database/Transaction Log File Growth

[StevenK]

I have created SQL server databases setting both the database and log files as having 'Automatic File Growth' and 'Unrestricted File Growth' (this is confirmed through the properties against the database). Would this mean that the only reason my transaction log file would ever get full would be the limit of physical space of the hard drive on which the database is sitting ?
Thanks in advance
Steve

 

[foxdev]

Not exactly; your log file will get full, at which time it will automatically expand (the default is 10% growth each time). Naturally, the hard maximum is your available disk space. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[StevenK]

foxdev : Thanks for the info. - The database is constucted with option to expand. Does this therefore imply that my limit for the database/log files is the hard drive space ?

 

[foxdev]

Yes, the disk space on the drive where that file is located (not necessarily where SQLS was installed) will be the hard limit, unless you add additional files that live on other logical disks. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[StevenK]

foxdev : Thanks again for the speedy response - my mind is now at rest.
Steve

 

[foxdev]

Keep in mind, though, that disk space can be taken up by a number of things, so while you're watching one log file's size another log or data file from a different database or a group of temp files can swallow all that free space in just a few minutes. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org