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 |
|
Ex
Posting Yak Master
166 Posts |
 Posted - 2005-04-03 : 21:33:38
|
| should a transaction log be cleared out after a full backup if not how is the best way to do this? |
|
|
Ex
Posting Yak Master
166 Posts |
Posted - 2005-04-03 : 21:48:31
|
| sorry i will be more clear if you dont back up the log can you truncate the log file? i have a full backup at the moment but my log file stay the same size i am assuming i am not truncating it should it be truncated aftear a full backup or do i specifiy it needs to be truncated? |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-04 : 02:34:17
|
| if you don't need point in time restoration, you can just truncate the log file otherwise you may need to create routine log backups to maintain it's size--------------------keeping it simple... |
|
|
|
|
|
|
full backup