Can MS SQL 2008 R2 backup database to a file on different network location…I've been unable to set network path for backup to other machine on local network via tasks-backup-destination.add location…
MS SQL Server 2008 R2 – Network Backup
backupsql serversql-server-2008-r2
Related Question
- Sql-server – How to restore Network backup to Network Path in SQL Server 2005
- SQL Server 2008 R2 – Fast Local Backup, Very Slow Backup via Network
- Backup – Difference in Backup File Size Using Ola Hallengren
- Sql-server – Command line tool / script to backup a remote SQL Server database to local disk
- Sql-server – SQL Server Agent unable to view network drives
Best Answer
I believe you can. We backup to a network location although we have the location mapped to a drive.
It seems you can use a UNC as well though according to this answer http://social.msdn.microsoft.com/Forums/sqlserver/en-US/965cd9c4-f4d5-4492-a202-f09b78d89ed1/how-to-backup-a-database-to-a-network-drive?forum=sqltools.
Have a look at the answer as there's some good considerations on here like if the sql service login has access to the network location.