Cross-domain backups using LiteSpeed (4379301)

The article describes the process to setup correctly the SQL Server instance and LiteSpeed to perform a cross-domain backup job. 

Steps to perform a SQL backup to an untrusted domain share:

• Open SSMS new query window
• Enable advanced options

EXECUTE sys.sp_configure 'show advanced options', 1;RECONFIGURE;

• Enable cmdshell

EXECUTE sys.sp_configure 'xp_cmdshell', 1;RECONFIGURE;

• Add windows credentials for remote share

xp_cmdshell 'cmdkey /add:targetcomputername /user:targetuser /pass:targetpassword'

• Run backup script, for example

exec master.dbo.xp_backup_database@database = N'Demo03', @backupname = N'%D - Full Database Backup', @desc = N'Full Backup of %D on %Y-%m-%d %I:%M:%S %p', @compressionlevel = 7,@filename = N'\\10.250.36.122\Backups\%D-%Y%m%d%H%M%S.bak',@init = 1