Post reply

Logs are not being restored on the secoundary server database

  • May 6, 2008 at 2:28 am

    #121291

    Hello Friends,

    I have implemented the Log shipping in SQL Server 2005, before it was running fine.

    But now it is not restoring the logs on the secoundary server, get the error

    "Executed as user: ServerName\SYSTEM. Unable to open Step output file. The step failed".

    logs are being copied on the secoundary server.

    I did not receive any another error, could you tell me where should I look to find error, or what can be the problem.

    Regards,

    Sanja

  • May 6, 2008 at 3:24 am

    #811071

    Doesnt seem to be a problem with Log Shipping itself. This seems to be a problem with the SQL Server Agent job trying to open the file to log its activity. Check the log file for the job and see if the path to the file exists and that the executing user has permissions to write to this file.

  • May 6, 2008 at 5:50 am

    #811118

    Hello,

    I checked the property of sql server agent, and in users and group it has admin right at server level and sql server.

    Do I need to check something specific. Let me know.

    Thanks,

    Priyanka

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

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