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.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2005-05-18 : 11:59:32
|
| Maximum file size for Data and Log files has been set to unrestricted file growth and the file growth is set to 10%. How about if I set the Maximum file size to restricted file growth? Do I lose anything by this setting?I make a full backup every night. Also, backup the trani logs every hour during work hours. Canada DBA |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-05-18 : 12:07:32
|
| If you set the maximum file size to a certain size, then the file will not be allowed to grow past that size. If you set it to unrestricted then the file will be allowed to grow until it fills the disk resource it is on. So whether or not you gain or lose anything by the setting would depend on your perspective.-------Moo. :) |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2005-05-18 : 14:56:00
|
How about if I choose a big but enough file size? Say 1GB or something more. All I need is to have the current day's transactions log. Remember that I backup trani logs every 1 hour. quote:
Originally posted by mr_mist
If you set the maximum file size to a certain size, then the file will not be allowed to grow past that size. If you set it to unrestricted then the file will be allowed to grow until it fills the disk resource it is on. So whether or not you gain or lose anything by the setting would depend on your perspective.-------Moo. :)
Canada DBA |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-18 : 17:59:37
|
| I wouldn't do this unless I was limited on the space I could use. If the log is growing to the point it's causing problems, then fix the issue or buy more space. If you hit the maximum size of the files and cannot autogrow, you're going to have issues.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Restricted file growth