Friday, March 9, 2012

Log File

If your database is set to unrestricted log file growth can anyone tell me why the log file becomes full? I get this error. "Back up the transaction log for the database to free up some log space. [SQLSTATE 42000] (Error 9002)" After about three or four days now on a consistent bases. I don't believe it is because I am running out of disk space. ???

TomWhat is your current filesystem ... FAT or NTFS ?|||It has to be the case, you can't get this error for any other reason other than when running out of disk...It is NTFS, isn't it?

No comments:

Post a Comment