Daniel O Asked: 2008-09-09 16:01:46 +0800 CST2008-09-09 16:01:46 +0800 CST 2008-09-09 16:01:46 +0800 CST Backup SQL Server to a Network Share 772 How do you backup an SQL Server Database to a Network Share? sql-server backup maintenance 2 Answers Voted Michael K Campbell 2008-09-19T06:33:19+08:002008-09-19T06:33:19+08:00 Assuming that the SQL Server Service you're using has access to the network location, you can see a hands-on example of how to backup to a network share in either of the following, free, videos: Backups with SQL Server Enterprise Manager Backups with SQL Server Management Studio This video also provides some information on other options and some caveats about backing up to network shares: SQL Server Backup Best Practices Daniel O 2008-09-18T22:31:26+08:002008-09-18T22:31:26+08:00 In order to backup (as part of a schedule SQL Agent Job) to a network share you need to make sure the SQL Server service, and the SQL Server Agent service are running as a Domain account that has access to the destination folder.
Assuming that the SQL Server Service you're using has access to the network location, you can see a hands-on example of how to backup to a network share in either of the following, free, videos:
Backups with SQL Server Enterprise Manager
Backups with SQL Server Management Studio
This video also provides some information on other options and some caveats about backing up to network shares:
SQL Server Backup Best Practices
In order to backup (as part of a schedule SQL Agent Job) to a network share you need to make sure the SQL Server service, and the SQL Server Agent service are running as a Domain account that has access to the destination folder.