Post reply

TRANSACTION LOG COPY JOB FAILED IN LOGSHIPPING

  • December 4, 2013 at 11:06 am

    #301051

    Hi All,

    I am facing copy job failed error in log shipping. when i configured logshipping backups are occurring normally, but the issue is when the secondary server searches for logfile in primary server that time it was showing

    error : the network path was not found

    my primary server name like this: ITI-PDP-DB\chandu

    i am given the primary server network path like:\\ITI-PDP-DB\chandu\Logshipping_backup

    if i give ip then it was showing error : the network path \\192.168.0.21\Logshipping_backup was denied.

    please help us

    Thank & Regards

    Chalapathi

  • December 4, 2013 at 10:24 pm

    #1670910

    Are you reffering named instance like this "ITI-PDP-DB\chandu"

    first try the network path in windows , if it is not working check and fix it.

    can provide more details like server1 and server2 with masked info and what are you trying with that.

    Regards
    Durai Nagarajan

  • December 5, 2013 at 12:36 am

    #1670931

    make sure your SQL service account has the rights to access network path.


    Praveen D'sa
    MCITP - Database Administrator 2008
    http://sqlerrors.wordpress.com

  • December 5, 2013 at 12:51 am

    #1670933

    Hi durai nagarajan,

    ya exactly its a named instance i have given the windows path also

    like \\192.168.0.21\foldername at that time i am getting

    error: the path \\192.168.0.21\foldername is denied error please help me

    Thanks

    Chalapathi

  • December 5, 2013 at 1:32 am

    #1670943

    give SQL service account full access to this folder


    Praveen D'sa
    MCITP - Database Administrator 2008
    http://sqlerrors.wordpress.com

  • December 5, 2013 at 1:48 am

    #1670950

    Hi Praveen,

    I had given those permissions also,still it was showing same error, please help us.

    thanks & regards

    Chalapathi

  • December 5, 2013 at 1:55 am

    #1670952

    basically from your secondary server you should be able to access backup folder, try to login to your secondary server with SQL Service account user name and password and then try to access backup folder

    Start -> Run -> \\servername\foldername

    if you are not able to access this folder than you have not given enough permission to this account.


    Praveen D'sa
    MCITP - Database Administrator 2008
    http://sqlerrors.wordpress.com

  • December 5, 2013 at 3:37 am

    #1670975

    cpathidba (12/5/2013)

    Hi Praveen,

    I had given those permissions also,still it was showing same error, please help us.

    thanks & regards

    Chalapathi

    It is the SQL Server agent service account that requires access to the share. Also, ensure you check both Share and NTFS permissions and set them appropriately

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

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

  • December 23, 2013 at 1:41 pm

    #1675676

    got fixed?

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

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