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 |
|
JananiK
Starting Member
2 Posts |
 Posted - 2008-05-09 : 01:09:54
|
| Hi,Could someone please let me know what are the exact steps to follow to truncate the transaction log files? As these log files grow very fast and there seems to be no space in the drive.Currently am using the below steps to truncate the log file:Step1:Use the below syntax:backup log <database name> with no_logStep2:shrink the log file. Right click the correct database and choose shrink file ->chosse the log -> okI would be grateful if someone can give me a proper solution.Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-09 : 01:19:35
|
| 1)Are you able to shrink or not with Backup log database --DBCC shrinfile2)If not , and if in emergency, Backup your database in other location and Change your database to simple recovery model and shrink a file. 3) You need to backup log every 15-30 mins to keep in control for long term purpose. |
 |
|
|
|
|
|
Truncation of Log Files