Home Forums SQL Server 2008 SQL Server 2008 - General Backing Up/Restore to non-local drive RE: Backing Up/Restore to non-local drive
SQListic
SSCertifiable
Points: 6904
More actions
September 6, 2012 at 9:50 am
#1534592
EXEC xp_cmdshell 'net use v: \\ServerName\foldername'
Here we are assigning V as drive letter to the \\ServerName\foldername'
-----------------------------------
BACKUP DATABASE [XYZ] TO
DISK = N'v\xyz.bak'
WITH stats = 10, format