SQL Log File - how to remove / reduce
-
Hi, I found that the Log file of my database has grown too fat. as i want to save some of the resources, i am thinking of deleting it. but i think such a direct deletion will hamper my database. can you please tell me how to DELETE / REDUCE the size of that log file. also, throw some light on how to read database log files. Thanking You. BSRK
-
Hi, I found that the Log file of my database has grown too fat. as i want to save some of the resources, i am thinking of deleting it. but i think such a direct deletion will hamper my database. can you please tell me how to DELETE / REDUCE the size of that log file. also, throw some light on how to read database log files. Thanking You. BSRK
What DB are you using, SQL Server? ADDED: Apologies, I should have read the title of the question!! You should look at your Recovery model. Maybe you could get away with a lower level of recovery. You cannot delete the Transaction Log. If you backup your log, it is automatically truncated. Then, you can shrink it. You can run backup with a TRUNCATE_ONLY option. Then shrink it. Steve -- modified at 14:37 Thursday 17th August, 2006
-
Hi, I found that the Log file of my database has grown too fat. as i want to save some of the resources, i am thinking of deleting it. but i think such a direct deletion will hamper my database. can you please tell me how to DELETE / REDUCE the size of that log file. also, throw some light on how to read database log files. Thanking You. BSRK
Shrinking the Transaction Log[^] Truncating the Transaction Log [^]
--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters