Post reply

SQL Backup across network - non domain

  • October 19, 2010 at 11:45 am

    #241881

    I have two servers, A and B. A has the SQL instance and database running on it. Server B has a Drobo SAN connected to it and I have shares on that. My objectice is to set the backup location to a share. I have the share mapped and can access it through UNC. My issue is that it is in a non-domain environment so I can't just set the service account to a domain account.

    What are my options here?

    Thank you in advance.

  • October 19, 2010 at 7:29 pm

    #1239436

    Have you tried creating the same user account, with the same passwords, on both machines, and use that account as the SQL Server Agent service startup account?

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • October 20, 2010 at 7:48 am

    #1239692

    Ray,

    That worked, thank you. I had tried setting the SQL Server service like this at first but did not set the Agent. After setting both to use the same local account credentials, it is now working.

Viewing 3 posts - 1 through 2 (of 2 total)

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