Post reply

Log shipping error

  • May 19, 2014 at 1:52 am

    #308183

    Hi All,

    I am new in log shipping. When I am generating log shipping from one server to another Server. I am getting below error:

    cannot open backup device "\\primary server\"

    operating system erroe 5(Access is denied)

    Restore Filelist is terminating abnormally(Microsoft Sql Server, Error:3201)

    Please anyone explain me , what is that error.

    Note: I am sysadmin and I have full access of the server.

    Thanks

  • May 19, 2014 at 4:02 am

    #1714555

    arooj300 (5/19/2014)

    Hi All,

    I am new in log shipping. When I am generating log shipping from one server to another Server. I am getting below error:

    cannot open backup device "\\primary server\"

    operating system erroe 5(Access is denied)

    Restore Filelist is terminating abnormally(Microsoft Sql Server, Error:3201)

    Please anyone explain me , what is that error.

    Note: I am sysadmin and I have full access of the server.

    Thanks

    Being a server administrator doesnt necessarily guarantee access. When you create a new share you need to set the Share permissions and NTFS permissions.

    Which part of the log shipping wizard are you at, i'm assuming you're attempting to restore the secondary database?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 19, 2014 at 5:30 am

    #1714581

    Hi,

    Thanks for the reply. Yes I am trying to restore in Secondary Database. Backup has been created in Primary Server, but its unable to copy from primary server folder to secondary server folder. I have given NTFS folder permission also as you told. But still I am getting same error.

    Thanks

  • May 19, 2014 at 11:19 am

    #1714730

    Are the folders setup as shares?

  • May 20, 2014 at 1:18 am

    #1714807

    arooj300 (5/19/2014)

    Yes I am trying to restore in Secondary Database.

    Manually or via the wizard?

    arooj300 (5/19/2014)

    but its unable to copy from primary server folder to secondary server folder. I have given NTFS folder permission also as you told. But still I am getting same error.

    Thanks

    Depending on the answer to my question above,

    What share permissions have you granted and to who?

    What NTFS permissions have you granted and to who?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 20, 2014 at 1:42 am

    #1714813

    yes folder are shared. and I am using with Wizard.

    Database-properties-Transaction Log Shipping

  • May 20, 2014 at 3:13 am

    #1714830

    arooj300 (5/20/2014)

    yes folder are shared. and I am using with Wizard.

    So, who did you grant permissions too??

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 20, 2014 at 5:21 am

    #1714868

    Thanks Perry,

    Now I am able to configure log shipping. I have changed the agent service from local system to network service. Its working fine 🙂

  • May 20, 2014 at 7:24 am

    #1714927

    as i suspected, you must grant Share\NTFS permissions to the SQL Server service and not yourself 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 9 posts - 1 through 8 (of 8 total)

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