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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-05-02 : 01:21:30
|
| Dear experts,How to truncate a log file?By taking Full Bacup can we make the log file empty? how can I make an automatic checkpoint?thank you in advanceVinod |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-02 : 01:35:06
|
| Take a look at: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62165&SearchTerms=truncate,log[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-05-02 : 02:09:35
|
| the command DUMP TRAN <DATABASE NAME> WITH NO_LOG is not working for me? I just replaced the database name with my database name..........please guide meVinod |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-02 : 02:21:37
|
| Avoid using Dump Tran, it is provided only for backward compatibility.Have you tried taking full backup of your database? What is the recovery model for the database? Have you read the link I posted?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-05-02 : 02:34:56
|
| yes I've taken the full backupVinod |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-02 : 09:49:04
|
| Use 'backup log db_name with truncate_only'. If the db is not in simple recovery mode, you should backup log periodically without truncate_only option. |
|
|
|
|
|
|
log file truncate