Home Forums SQL Server 2008 SQL Server 2008 Administration SQL backup to network drive RE: SQL backup to network drive

  • December 3, 2012 at 8:44 am

    #1564917

    sqlGDBA (11/30/2012)

    I think you only need to change the SQL Agent service account, not the SQL Server service account.

    Yes, if you're running all your backups as scheduled jobs, that's true. But if you expect to run ad hoc backup (or restore) commands from SSMS, for example, then I think the SQL Server service also needs access.

    John