Home Forums SQL Server 2008 SQL Server 2008 - General Transaction Log Question Related to Log Shipping and DR (What's in a T-Log?) RE: Transaction Log Question Related to Log Shipping and DR (What's in a T-Log?)

  • March 4, 2014 at 10:12 am

    #1693979

    If it's a SQL login you have to make sure that the SID for the login is the same on both servers, otherwise the database user won't reference the login and won't be able to access the DB.

    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