• Andy Hogg (7/24/2009)


    True you can use a UNC path in a scripted backup \ restore as per the example given, but you can also use UNC paths within Enterprise Manager or Management Studio too. You don't need to use a script if you don't want to.

    Agreed. I've set up backup plans in both that backup to a network location rather than the local machine. Probably not recommended if you have 200Gb database backups, but the sort of database backup sizes I've generally been dealing with (less than 3Gb) haven't ever had an issue.