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 but for this example this like a LEVEL ZERO in RMAN). 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).
...
12. This screen sets up the backup file deletion plan. Make sure you point it (middle of screen) to where you sent your backups (see Step #10), click the Include Subfirst-Folders level subfolders box and choose the BAK file extension. This example shows files older than 2 weeks will be deleted.
...