• 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