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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2007-12-13 : 21:27:51
|
| How to setup a sql 2005 maint plan for truncate log ?Is it possible or do need to create a job and and in job step mention belowBackup log DatabaseName with truncate_onlyHow do i issue the checkpoint?...please let me know? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-15 : 01:15:33
|
| No, don't do truncate if db is not in simple recovery model. Just backup db and log in the plan. |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-15 : 02:31:57
|
| Lets say we are doing DB backup and Tlog backup, but how to truncate the log?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-15 : 02:33:48
|
| You mean reduce log file size? How big is it? |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-15 : 02:37:25
|
| 705,000 KBHow would I truncate log and how would I reduce the size of log?We are into 24x7 production environment |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-15 : 03:09:03
|
| You can shrink it, but better to leave it because shrinking log is performance killer. |
|
|
|
|
|
|
truncate log