Post reply

Where is the backup log created?

  • April 16, 2010 at 4:23 am

    #231857

    I just wonder where I can find the backed up files for my database when I run the following command:

    USE DatabaseName

    GO

    DBCC SHRINKFILE(<TransactionLogName>, 1)

    BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

    DBCC SHRINKFILE(<TransactionLogName>, 1)

    GO

    I am using SQL 2005.

  • April 16, 2010 at 4:38 am

    #1152678

    You are not backing up. The above command truncate the log file without backing up.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • April 16, 2010 at 5:12 am

    #1152701

    K. Hari Das (4/16/2010)

    I just wonder where I can find the backed up files for my database when I run the following command:

    USE DatabaseName

    GO

    DBCC SHRINKFILE(<TransactionLogName>, 1)

    BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

    DBCC SHRINKFILE(<TransactionLogName>, 1)

    GO

    I am using SQL 2005.

    Go and look the BOL.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • April 16, 2010 at 6:34 am

    #1152765

    Thanks for the reply :))

  • April 16, 2010 at 7:26 am

    #1152814

    K. Hari Das (4/16/2010)

    Thanks for the reply :))

    Ur welcome....:-)

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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