hi, a peer of mine would like to be self sufficient in bringing small .bak's over to her local without rdp'ing to the sql server or mapping a drive to that server or asking our dba for help.
I dont even think she would mind if sql sent the .bak straight across the wire to her c: drive.
is there a way running ssms locally but connected to a remote sql server to direct the .bak to a local folder? i usually run this command when i'm backing up to another server's z:drive.
BACKUP DATABASE [xx] TO DISK = N'Z:\Backup\xx.bak' WITH NOFORMAT, NOINIT, NAME = N'DW-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO