Hi There
I recently read up and found an msdn forum post that said the 4gb limit only applied to data files not log files.
However recently i had an error on a sql express database saying that the log file was full, the database log file was set to auto grow and there was plenty of space left.
So i am guessing the 4gb limit applies to any database file mdf or ldf, is this correct ?
Thanx
Hi,
you have to backup your log file.
BACKUP LOG <DB_NAME> WITH TRUNCATE_ONLY -- modell "simple"
BACKUP LOG <DB_NAME> -- modell "full"
or shrink it without backup:
BACKUP LOG <DB_NAME> WITH NO_LOG
|||
I cannot do this, DB is in simple recovery. It is one big transaction that causes this, i cannot do this in the middle of a transaction.
Thanx
|||
There is not a size limit for log files.
From: http://msdn2.microsoft.com/en-us/library/ms345154.aspx
"The 4 GB database size limit applies only to data files and not to log files."
Did you check the computer application log file for errors?
The SQL Server log file?
|||
Thanx Arnie
It just is so strange that it happended exactly when the log file hit 4Gb?
But thanx for the feedback
