SQL Server Performance Forum – Threads Archive
T-Sql Commandwhats the t-sql command to change the logfile into Unrestricted file growth?in 2005 Default its restricted file. I am trying to change from SQL Server Management studio but its not saving the settings
alter database yourdb
modify file (NAME =yourlogicalfilename,MAXSIZE = UNLIMITED )
Check BOOKS ONLINE topic "ALTER DATABASE" for complete syntax..
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.