This will walk you through setting up a FULL backup solution for ALL databases on a server and setup the cleanup task to delete older backupsbackup files.
NOTES and Assumptions:(NOTE: You can in Step #7 choose individual database(s) or Differential backups). This walk-through assumes you have permissions to access disk and that disk has adequate space.
- It is very important to make sure you calculate the size that your backups will consume on the disk and size your disk needs accordingly. The wizard gives you the option to expire backups and remove them.
- This walk through assumes you have access to the SQL Server Windows machine via Windows Authentication.
- This example is for a FULL backup (think LEVEL ZERO in RMAN) ... You can in Step #7 choose differential backups. If you setup a Differential Backup(s) you can then apply PIT recovery via transactions logs assuming all files & logs are present during recovery. But that is a different topic.
STEPS:
1). Log into box running SQL Server (i.e. SF-DUBLIN17).
...
8.On the next screen choose the order for tasks to be run. Obviously we wan want the backup run first.
(NOTE: Like I mentioned above you could also choose other tasks like Rebuild Index, Reorganize Index, Shrink Database, etc ...)
Now click NEXT.
9. On the next screen we will determine which databases to backup and where to back them up.
...
12. This screen sets up the backup file deletion plan. In this example we will delete . Make sure you point it (middle of screen) to where you sent your backups (see Step #10), click the Include first-level subfolders box and choose the BAK file extension. This example shows files older than 2 weeks will be deleted.
Now click NEXT.
13. Determine where to write the backup report. In this example we will write it to E:\Backups\Backup_Reports
...