SQL Server Performance Forum – Threads Archive

unable to copy the initialization file to the seco

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

KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;811890 to resolve the issue. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

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

]]>