Gurus Backup to Network Machine

  • Hi All,

    Is it possible to take the Database Backup to a network machine?

    Jag

     

  • Yes.

    1. Check the logins that SQL Server services use. These need to be Domain accounts with access to the network drive/directory.

    2. Run the backup job using the full UNC path to the network directory.

    -SQLBill

  • And if the SQL Server runs under a local account (not domain account) - which permissions shall I give on the network share to allow acces?

  • If the services run as Local System, then they can only access the 'local' server. If you want to access a network (domain), the services must be a domain account.

    -SQLBill

  • Thanks to all

Viewing 5 posts - 1 through 4 (of 4 total)

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