4gb limit

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