I have created several jobs in mssql 2005. One is a backup databases job and the other is cleanup old databases. Currently they backup to a local drive E.
Can i back them up to a shared drive on another computer? If so do I have to create anew job and delete the old one or is there a place I can go to edit the location of where my backups are currently going and point them to the new location.
If it is possible to make backups on a shared drive, do I need to create a mapped drive to do this backup or can I do it with just a network path typed in?