February 8, 2009 at 4:55 am
Hi
I am unable to change the maxfilesize of logfile to unlimited.I am able to change the initial size,filegrowth.I issued the command
Alter database xxx modify file(name='xxx_log',size=10mb,filegrowth=200mb,maxsie=unlimited).
filesize and filegrowth has been changed,but maxsize is not changing to unlimited.KIndly help
February 8, 2009 at 5:34 am
You have a typo (maxsie instead of maxsize) but I suspect that you had this only when you wrote the alter table in your message and not in the code that you ran. In any case according to books on line when we modify a file, we can modify only one property each time that we run alter database statement. Try to modify only the file’s maximum size in one statement and let us know if it worked for you.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 8, 2009 at 5:44 am
Hi
I put correct statement only. I tried one statement at a time also. I am getting the output( command completed successfully) .But when i put sp_helpdb xxx then maxsize is not updating. it is still showing the old one. I triend through ssms also .The result is same.Pls help
Binu
February 8, 2009 at 7:23 am
I’ve just checked it on my machine. It seems that if I modify the log file to have unrestricted growth, sp_helpdb does specify a limit, but it is a limit that I’ll never reach. If I do limit the log size, it will show the correct limit. If I specify unlimited again, it will change the limit again to a size that there is no way that I’ll reach. Don’t know why it doesn’t specify unrestricted just like it does with the data file, but since I view that limit as a theoretic one, I take it as if the restriction is unlimited.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 8, 2009 at 8:35 pm
I have just verified, it looks like we can set the maxzise='unlimited' can only be set to data file not to log file.
February 9, 2009 at 10:53 am
Thanks alot
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply