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.
BACKUP LOG dbname
The stmts executed without giving any errors.
I guessed that by default the backup file will be created in " Crogram 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.