January 19, 2011 at 10:06 am
I would like to set UNLIMITED to maintain a default config in all my logfiles.
I have a 7 server. All of them, have the same configuration but distinct databases. Some logfiles accept the UNLIMITED, but others don't.
I'm using the version bellow:
Microsoft SQL Server 2008 Enterprise Edition (SP2).
I tried by putting T-SQL bellow and I tried to change by interface too, but I didn't get results. I can't truncate the log because I'm using the last version of SQL Server.
USE[master]
GO
ALTERDATABASE[databasename]MODIFYFILE(NAME=N'databasename_Log',MAXSIZE=UNLIMITED)
GO
Can you give me a solution for this problem?
January 19, 2011 at 11:44 am
There's no solution because there's no problem. Check the ones that won't accept unlimited and calculate the actual size limit. You'll find it's 2 TB. 2TB is the maximum size a single transaction log file can be. Hence for a tran log, 2TB = unlimited.
p.s. Truncate the log? Why?
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply