Where is the log file backup gone? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Where is the log file backup gone?

I have taken a backup of log file using QA.Here is what I have done.
USE dbname
GO
BACKUP LOG dbname
WITH TRUNCATE_ONLY
The stmts executed without giving any errors.
I guessed that by default the backup file will be created in " C:program FilesMicrosoft SQL ServerMSSQLBACKUP".But it was not there.
I am wondering where the backup file gone.
You mentioned with TRUNCATE_ONLY clause and this statement of BACKUP now remove the inactive part of the log without making a backup copy of it and truncate the log. It is advised to perform a full backup immediately after TRUNCATE_ONLY or NO_LOG caluses are used. This will help to recover the database if any issue arises. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>