Post reply

Transaction Log Shipping and Stored Procedures

  • November 17, 2009 at 10:07 am

    #216813

    Hello World,

    I can't remember if Transaction Log shipping will ship over changes made to Store Procedures and Functions. Or does it only ship over changes to tables/user data.

    Thanks!

  • November 17, 2009 at 12:32 pm

    #1080469

    All changes to a database are logged (including schema changes). Since log shipping takes the log backups (which contain all the changes) and restores them on the secondary, all changes to the database are re-done on the secondary.

    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

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

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