I have a SQL Server (2000, 2005 and 2008) and I'd like to use SQL Agent (or even a simple backup database 'xxx' to disk = 'yyy'), to backup to remote drives.
I.e: i have a mapped drive in the SQL machine, for example: "M:" which maps to \\otherbox\someshare
By default SQL Server won't allow you to backup to such drives, but I think that there's a way to enable that. Can somebody point me to the docs?
Thanks in advance.