Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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(NOTE:

 

NOTES and Assumptions:

  • You can in Step #7 choose individual database(s) or Differential backups but for this example

...

  • I am demonstrating a backup that resembles a LEVEL ZERO in RMAN).

...

  • If you setup a Differential Backup(s) you can then apply PIT recovery via transactions logs.
  • 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. 

STEPS:

1). Log into box running SQL Server (i.e. SF-DUBLIN17).

...