June 25, 2013 at 2:25 am
Hi all,
I setup a log shipping between databases across two instances. the setup was complete. But when i see the error log i got this message.
Progress,1,QBSRECPU04,LSBackup_IPE_QUOTE_OCT_17,Log shipping backup log job step.,,2013-06-25 10:00:13.19*** Error: Backup failed for Server 'QBSRECPU04'. (Microsoft.SqlServer.SmoExtended) ***<nl/>2013-06-25 10:00:13.22*** Error: An exception occurred while executing a Transact-SQL statement or batch.(Microsoft.SqlServer.ConnectionInfo) ***<nl/>2013-06-25 10:00:13.22*** Error: Cannot open backup device 'd:\Log_shipping_shared\IPE_QUOTE_OCT_17_20130625043012.trn'. Operating system error 3(The system cannot find the path specified.).<nl/>BACKUP LOG is terminating abnormally.(.Net SqlClient Data Provider) ***<nl/>2013-06-25 10:00:13.26----- END OF TRANSACTION LOG BACKUP -----<nl/><nl/>Exit
June 25, 2013 at 2:36 am
The clue lies with "The system cannot find the path specified".
Check that the path you have specified for your backups exists and that the account log shipping is running under has permissions to read and write to that location.
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
June 25, 2013 at 2:42 am
How to check that account log shipping is running under has permissions to read and write to that location.
June 25, 2013 at 3:24 am
Note down the service account your sql agent running.
then Right click the folder your trn backup files are there -> security tab-> check there if account has Full permission.
June 26, 2013 at 8:11 am
Primary server's service account should have write privileges on the backup folder and Secondary server's service account should have read privileges on the backup folder.
Let any one know if i am wrong?
Thanks,
I’m nobody but still I’m somebody to someone………….
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply