SQL Server Performance

unable to copy the initialization file to the seco

Discussion in 'SQL Server Log Shipping' started by sramesh, Apr 12, 2006.

  1. sramesh New Member

    hi All,
    I have configured logshipping, in final stage i got the error.
    i have two systems. primary, secondary.
    what is the problem?

    Thanks
    S. Ramesh
  2. satya Moderator

  3. zieglers New Member

    hi there,

    1. ensure that you give the necessary r/w permissions to the folders where the logs are gonna be shipped.

    2. check the mssqlserver service and sqlagent service accounts. They should be started with the domain account (again with the necessary permissions)
    otherwise you can have no control on network resources. Also service accounts should be added to local admin group on the servers as well

    3. again be sure that at the final RESTORE stage at the destination, while the transaction logs are being restored, there should not exist any active connection or transaction on the db to be restored. Be sure that you do NOT MONITOR that db at the time of restore with Enterprise Manager or any other tool.

    zieglers

Share This Page