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?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…