sql log file
-
-
hii all, Am working with sql server 2000,i have a series problem my database log file is expanding in unusual way; my data file(MDF) just 50MB but my log is 2 GB can u imagine that. i know i can restrict size but why its expanding like this? marcoryos
Wow 2 GB is quite a lot, make sure there are no errors, you can avoid using the LOG but changing to Simple. Thought to let you know! Al
-
hii all, Am working with sql server 2000,i have a series problem my database log file is expanding in unusual way; my data file(MDF) just 50MB but my log is 2 GB can u imagine that. i know i can restrict size but why its expanding like this? marcoryos
What is the recovery model set to? Unless it is 'simple', the log file will not be automatically truncated, but will continue to grow until you truncate it either by issuing a 'backup log with truncate only' or by making a full backup and truncating the log as part of the backup command. Otherwise all changes are saved for possible use in restoring the database changes since the last backup. The 'simple' recovery model says you are only going to depend on backups and won't use logs for restore, so the log will be truncated as soon as changes are commited. Absolute faith corrupts as absolutely as absolute power Eric Hoffer The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not. Eric Hoffer