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 - 2005-06-08 : 08:19:59
|
| vipinkailas writes "I am periodcally gettig the Transaction log full messages from our SQL 2k server. Each time i truncate the log to restart the application.Is there anyway to truncate the transaction log periodically? Whether log shipping will help to solve this problem?" |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2005-06-08 : 08:47:00
|
| backing up the database or log will truncate. |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-06-08 : 09:02:23
|
| If you don't need point in time recovery, then change your database model to simple and SQL Server will handle truncation of the logs automatically. -------Moo. :) |
|
|
|
chetancool
Starting Member
34 Posts |
Posted - 2005-06-09 : 09:14:40
|
| Hi..Otherwise schedule a backup of transaction log. It will ensure that ur transaction log is within the controlled size and ur database can be recovered in case of any failure (it u have latest transaction log backup).Keep Smiling. |
|
|
|
|
|
|
SQL Server Transaction Logs