Post reply

BACKUP LOG with trucate_only

  • September 28, 2010 at 3:55 am

    #142095

    Backup log database name with truncate_only'

    what actually this statement is doing?

    Is it taking a log backup?If yes where is the location of backup.

    will it truncate the inactive data?

  • September 28, 2010 at 4:03 am

    #1228226

    That discards inactive log records and does not write a backup file out.

    It will break your log chain, meaning you cannot take log backups or do point in time recovery until you take a full or differential backup.

    Please read through this - Managing Transaction Logs[/url]

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 28, 2010 at 4:08 am

    #1228227

    Thank u

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply