T-Sql Command | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

T-Sql Command

whats 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..
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>