patternsqlMinor
MS SQL Server 2008 R2 network backup
Viewed 0 times
2008sqlservernetworkbackup
Problem
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...
Solution
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.
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.
Context
StackExchange Database Administrators Q#66621, answer score: 6
Revisions (0)
No revisions yet.