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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-26 : 09:17:31
|
| Vijay writes "My database transaction log file keep on increasing day by day.i just want to delete some transaction after a period of time mannually.plz suggest me the way to delete the transaction log." |
|
|
Jay99
468 Posts |
Posted - 2002-03-26 : 09:36:30
|
quote:
...plz suggest me the way to delete the transaction log."
sp_detach_db and then delete the file . . . (that's not what you me to suggest?)Take a look at BACKUP and DBCC SHRINKFILE commands in BOL.Also, plz make sure you know what you are doing before you start mannually delete transaction.Jay<O> |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-26 : 10:10:18
|
quote:
"My database transaction log file keep on increasing day by day.i just want to delete some transaction after a period of time mannually.plz suggest me the way to delete the transaction log."
Why don't you just back up your transaction log? It will automatically truncate it. It won't shrink the file size, but it will keep it from expanding. Plus, you should ALWAYS have a backup strategy for your database and log files. The whole point of having a transaction log is to provide data recovery. If you delete the log file and your data file gets corrupted, guess what? You've got NOTHING.You can also set your database to truncate log on checkpoint, this will help keep the log from filling up. Books Online has details on this. |
|
|
|
|
|
|
Decreasing The Size Of Database Transaction Log