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 |
|
puja
Starting Member
18 Posts |
 Posted - 2005-03-07 : 17:26:00
|
| hi, I am looking for a script which would delete my old log from my sql database.can someone suggest me? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-07 : 18:34:46
|
| Why do you want to delete the log file?Tara |
 |
|
|
puja
Starting Member
18 Posts |
Posted - 2005-03-09 : 11:36:16
|
| I am not saying I would like to delete all, I would like to delete only 6 months old items. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-09 : 12:30:03
|
| So what do you mean old log then? Are you just talking about data in a table? If so then a DELETE with the appropriate WHERE clause will do it. If that's not what you are talking about, then please be more significant.Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-10 : 00:43:51
|
"please be more significant"Yeah, stand up tall at the back there ...  Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-10 : 16:04:20
|
| That is too funny. I type very fast and sometimes type different words than I was thinking. I should reread my posts to make sure what I wanted to say is what I typed....then please be more specific.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-10 : 23:09:33
|
| Do you mean the error log?Do you mean the transaction log file (.ldf) of one of the databases? Do you mean a log table?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-11 : 05:53:41
|
| My wild stab in the dark would be that he wants to delete stuff that is more than 6 months old.-------Moo. :) |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-13 : 21:58:35
|
quote:
Originally posted by mr_mist
My wild stab in the dark would be that he wants to delete stuff that is more than 6 months old.-------Moo. :)
i concur, he he hein addition, are concerned with an increasing log size which is why you want to delete the "old log"?--------------------keeping it simple... |
|
|
|
|
|
|
delete log db