Post reply

Log Shipping and Backup

  • October 10, 2004 at 8:47 pm

    #161649

    I'm planning to use log shipping for my standby server.  Currently I have jobs created for the regular backups (full,differential) and transaction logs.  From what I've read in the documentation, you can create the log shipping throught the maintenance plan wizard.   And this will create jobs for you.  Does it mean that I have to disable my previous jobs in order not to mess up with the log shipping?  Can I also use the backup files  (full, differential and transaction logs) created by the log shipping and restore it to the another server? Or is there a tag in the backup files that it can only be used for log shipping and not for ordinary restore?   

  • October 11, 2004 at 3:38 am

    #526105

    You will have to remove your trx log backup jobs, and also ensure no jobs truncate the log.  Full and differential backups will not break the chain of log backups.

    You can use the trx log backups for regular restores, not a problem.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

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

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