Post reply

Log shipping issue

  • October 18, 2011 at 9:01 am

    #245493

    Hi,

    I am trying to setup logshipping between two 2008 R2 sql server databases on two different servers.

    Both are windows 2008 serveres.

    I have the sql login created with sysadmin privileges on both the servers and also granted windows admin privileges.

    The full backup of the primary database is on D:\backup\TLshipping\testdb.bak

    But I am getting the error - Cannot open backup device \\server1\d$\backup\TLshipping\testdb.bak.Operating system Error 5(access denied).

    But the sql login has sysadmin and windows admin privilges on both the servers.

    Can anyone please let me know what could be the reason for this access denied error?

    Thanks.

  • October 18, 2011 at 9:14 am

    #1396064

    Cannot open backup device \\server1\d$\backup\TLshipping\testdb.bak.Operating system Error 5(access denied).

    Please verify SQL Server Service Account & its privileges.

  • October 18, 2011 at 9:35 am

    #1396093

    The service run with same windows login which has sysadmin privileges on both the servers.

  • October 18, 2011 at 9:52 am

    #1396123

    The service run with same windows login which has sysadmin privileges on both the servers.

    Can you login to physical box with SQL Server Service Account & access this files?

    '\\server1\d$\backup\TLshipping\testdb.bak'

  • October 21, 2011 at 7:44 am

    #1397969

    Can we setup logshipping between two servers which are not part of a single domain.

    They are two independent servers.

  • October 21, 2011 at 8:13 am

    #1397997

    You have both the servers running under the same service account? They are not in the same domain, so how did you manage that?

    Did you use identical local account? or do you have cross domain trust set up?

    -Roy

  • October 21, 2011 at 8:18 am

    #1398001

    They are not running with the same service account.

  • October 21, 2011 at 8:22 am

    #1398005

    Are you getting the error on the copy job or the restore job? Also have you tried not using the hidden share but instead creating an actual shared folder?

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • October 21, 2011 at 8:25 am

    #1398011

    Do you have cross domain set up? How do you make sure that the Service account of Server A has all access to the Folder in Server B to copy the log files over?

    -Roy

  • October 21, 2011 at 9:30 am

    #1398070

    Cannot open backup device \\server1\d$\backup\TLshipping\testdb.bak.Operating system Error 5(access denied).

    I've had issues before using the admin shares like that across servers. Get rid of it. Create an actual share on the \\server1 that points to the proper directory, grant the appropriate "Sharing and Security" and change your path to be:

    \\server1\LogShipping

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

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

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