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 |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2008-05-02 : 11:55:35
|
| Any one explain me about this query exactly wat it will dobackup log iiswebappauditdb with truncate_only |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-05-02 : 12:03:25
|
| truncates the transaction log file. (ldf) |
 |
|
|
velliraj
Yak Posting Veteran
59 Posts |
Posted - 2008-05-02 : 12:14:21
|
| Did it take any back up of log file if so, where the backup will be stored? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 20:52:24
|
| No backup. If you want to backup log, should run something like:backup log iiswebappauditdb to disk = '...' |
|
|
|
|
|
|
Explain