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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 BACKUP LOG...

Author  Topic 

danielc
Starting Member

49 Posts

Posted - 2008-01-31 : 17:37:59
Sorry to ask this really stupid question...

When the command BACKUP LOG <database name> WITH TRUNCATE_ONLY is executed, where does it backup the log file to? It executes successfully. But where does it go?

Thanks

D

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-31 : 23:11:15
No where, sql just truncates committed transactions from log file.
Go to Top of Page
   

- Advertisement -