need help with log shipping error

  • 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

  • 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

  • both are running under sql server agent services account

  • 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

  • the folders are in place

  • 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

  • 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

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

    Date10/10/2013 2:14:01 PM

    LogJob History (LSCopy_SQLTEST_TCB_LOAD)

    Step ID1

    ServerSQLTEST2

    Job NameLSCopy_SQLTEST_TCB_LOAD

    Step NameLog shipping copy job step.

    Duration00:00:01

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

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

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

    2013-10-10 14:14:02.04Retrieved 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.06Copying 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)

  • 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

  • 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

  • ----

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

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