May 27, 2008 at 9:22 am
Hello,
Its happening something curious to me.
I've created one database in SQL Server 2005 with one datafile with xyz MB with unrestricted file size and a log file abc unrestricted file size.
When i look at the size of the file size of the transaction log it appears to me with a restricted file size of 2047KB :o$
I run the following command and when i go to SSMS it appears like if i haven't run this command.
USE [master]
GO
ALTER DATABASE [DATABASE_NAME] MODIFY FILE ( NAME = N'file_name_log', MAXSIZE = UNLIMITED, FILEGROWTH = 10240KB )
GO
Is there any bug that i don't know?
Can anybody help me on this point?
Thanks and regards
JMSM 😉
May 27, 2008 at 9:43 am
Sorry,
The file growth when we put the unrestricted growth is 2TB not 2GB
"By 10 MB, restricted growth to 2097152 MB"
;o$
Thank and regads
JMSM 😉
March 21, 2011 at 10:28 am
Hi, if you haven't found the answer yet, it was addressed here: http://www.sqlservercentral.com/Forums/Topic493874-146-1.aspx
The default 'Unrestricted' log size IS 2TB in SQL Server 2005.
_________________________________
seth delconte
http://sqlkeys.com
March 21, 2011 at 11:37 am
Please note: 3 year old thread
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 21, 2011 at 12:01 pm
I answered him; what have you done? 😉
_________________________________
seth delconte
http://sqlkeys.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply