Post reply

need help with log shipping error

  • October 10, 2013 at 11:15 am

    #278065

    hi all I am getting this error

    *** Error: Access to the path '\\sqltest\d$\logshipping' is denied.(mscorlib) ***

    the backup job runs but the copy job is failing

  • October 10, 2013 at 11:23 am

    #1657658

    harita (10/10/2013)

    hi all I am getting this error

    *** Error: Access to the path '\\sqltest\d$\logshipping' is denied.(mscorlib) ***

    the backup job runs but the copy job is failing

    Is it possible that your copy job is using different credentials than your backup job?

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • October 10, 2013 at 11:38 am

    #1657662

    both are running under sql server agent services account

  • October 10, 2013 at 11:45 am

    #1657665

    Did you verify that your logshipping folder didn't go away? I've had that happen to me.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • October 10, 2013 at 11:49 am

    #1657667

    the folders are in place

  • October 10, 2013 at 11:53 am

    #1657670

    I copied the backed up log file to the B server folder and run the restore job and it worked it, so only copy job is not working

  • October 10, 2013 at 12:12 pm

    #1657673

    I found this on MSDN:

    You are using $ share which will be accessible by administrators, so make sure your service account is added to Local administrators group of both the servers.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • October 10, 2013 at 12:15 pm

    #1657674

    I tried that and this is the error message if it helps

    Date 10/10/2013 2:14:01 PM

    Log Job History (LSCopy_SQLTEST_TCB_LOAD)

    Step ID 1

    Server SQLTEST2

    Job Name LSCopy_SQLTEST_TCB_LOAD

    Step Name Log shipping copy job step.

    Duration 00:00:01

    Sql Severity 0

    Sql Message ID 0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted 0

    Message

    2013-10-10 14:14:02.02 Starting transaction log copy. Secondary ID: 'c047582c-1987-4229-98d0-a1ec105a315a'

    2013-10-10 14:14:02.03 Retrieving copy settings. Secondary ID: 'c047582c-1987-4229-98d0-a1ec105a315a'

    2013-10-10 14:14:02.04 Retrieved copy settings. Primary Server: 'SQLTEST', Primary Database: 'TCB_LOAD', Backup Source Directory: '\\sqltest\d$\logshipping', Backup Destination Directory: 'D:\logshipping', Last Copied File: '<None>'

    2013-10-10 14:14:02.06 Copying log backup files. Primary Server: 'SQLTEST', Primary Database: 'TCB_LOAD', Backup Source Directory: '\\sqltest\d$\logshipping', Backup Destination Directory: 'D:\logshipping'

    2013-10-10 14:14:02.08 *** Error: Access to the path '\\sqltest\d$\logshipping' is denied.(mscorlib) ***

    2013-10-10 14:14:02.10 ----- END OF TRANSACTION LOG COPY -----

    Exit Status: 1 (Error)

  • October 10, 2013 at 12:21 pm

    #1657677

    Is it possible to have a share on your receiving database server for the logs instead of using the administrative share?

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • October 10, 2013 at 12:33 pm

    #1657682

    hi thank you for this

    ''You are using $ share which will be accessible by administrators, so make sure your service account is added to Local administrators group of both the servers.''

    I tried it earlier and it failed and

    tried it again and it is working now

    thank you

  • October 10, 2013 at 1:21 pm

    #1657705

    ----

Viewing 11 posts - 1 through 10 (of 10 total)

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