Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2012-05-04 : 06:28:40
|
| Hi All,Is there any way to truncate the log file via procedure. I Wanted to keep this on weekly job.Please suggest |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-05-05 : 09:34:13
|
| You should be taken frequent (every 15 minutes) transaction log backups if your database is in full recovery model. If you don't need point in time recovery, you can switch the recovery model to simple and the transaction log will truncate automatically. |
 |
|
|
|
|
|
Truncating database log