October 10, 2013 at 11:15 am
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
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
both are running under sql server agent services account
October 10, 2013 at 11:45 am
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
the folders are in place
October 10, 2013 at 11:53 am
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
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
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)
October 10, 2013 at 12:21 pm
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
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
----
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply