You can create a public share on your computer on the fly like this in DOS:
net share backup=C:\MyBackups
You can then connect with sqlcmd and do:
backup database MyDatabase to disk='\MyComputer\backup\MyDatabase.bak' with stats=1
Sometimes instead of MyComputer I have to put my IP address.
At the end you do:
net share backup /d
No special privileges needed for this.
commented on Jun 27 2012 1:59AM