Home Forums SQL Server 2008 SQL Server 2008 High Availability Best practice to setup a test server to restore backups from production automatically? RE: Best practice to setup a test server to restore backups from production automatically?

  • October 23, 2013 at 10:30 am

    #1661022

    joshd 1807 (10/23/2013)

    100% full access. I can access it from the server with the Windows Authentication account I am using

    I didn't ask about the account you're using. I asked if the SQL Server service account (the account that SQL Server is running under) has access. The account you're using is mostly irrelevant.

    It's perfectly possible to restore from a UNC path, SQL just has to have permissions to access that path.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass