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 |
|
ryanlcs
Yak Posting Veteran
62 Posts |
 Posted - 2007-01-18 : 00:53:31
|
| I have the TSQL in my DTS. But I do not understand what exactly it do.Does it Backup the Log file or it just truncate the log file?"BACKUP LOG Database WITH TRUNCATE_ONLY"Thanks. |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2007-01-18 : 01:51:27
|
| This will remove inactive portion of the log without taking a backup.Don't sit back because of failure. It will come back to check if you still available. -- Binu |
 |
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2007-01-18 : 03:18:04
|
| when the transaction log of your database grow and you have space limitation in your server , this first step before shrinking Transaction log. Madhu |
|
|
|
ryanlcs
Yak Posting Veteran
62 Posts |
Posted - 2007-01-18 : 08:37:09
|
| Yes. I run this before shrinking the log file. So, it didnt actually Backup the database.Thanks. |
|
|
|
|
|
|
Backup Log