An introduction to ApexSQL Backup

In this video, we will take an overview of some main features in ApexSQL Backup.

Transcript

Hello, and welcome to this ApexSQL Backup DEMO introduction. ApexSQL Backup is a powerful and intuitive database backup tool for SQL Server. It’s wide range of features enable users to configure SQL backup and restore jobs with advanced scheduling, to execute log shipping jobs to multiple destinations as well as to schedule and execute index maintenance tasks.

In this video, we’ll demonstrate some of its features and capabilities

In order to backup a database from a desired server, let’s first connect to that server by clicking on the Add button and selecting a SQL Server along with authentication type:

The next step would be to select desired database from server’s panel list. Right click on it and choose the Backup option or simply click on Backup button in Tasks group:

Once clicked, the Create backup wizard will be opened and our selected database by default is presented in Databases text box. To add another simply click on the Database browse button. Choose the preferred backup type, full database is selected by default, and choose to backup to Disk or Azure blob storage. Add a backup destination path or simply leave the default SQL Server path location if that is more convenient.

Note here that if more than one backup destination is added then those backups will be split across those destinations:

Run the backup job immediately by default or set the schedule for it by clicking on the Schedule radio button. The Add schedule wizard will open automatically. Under the Frequency area, choose the policy to be executed: Once, Daily, Weekly or Monthly. Set Daily frequency and Duration. Under the Summary section, the info about the chosen schedule parameters is presented:

In the Advanced tab, specify backup options such as backup verification, compression, encryption and when to delete old backup files:

To choose if an email will be sent on job completion, navigate to the Notification tab. Select whether to send notifications by checking the box in front of one or more job outcomes, and provide Email recipients:

Click Finish at the form bottom to execute or schedule the job:

C:\Users\Gole\AppData\Local\Temp\SNAGHTML17806217.PNG

To restore a database from a SQL Server select the desired database from server panel list, right click on it and choose Restore option or simply click on Restore button in Tasks group:

In the Restore backup wizard choose whether to forcefully close any existing connections to the database that might block a restore job and whether to overwrite the existing database:

On the same form, choose whether to restore from the specific backup, or from a folder scan.

If a specific database backup is selected, it is required to provide a file path of the backup file. To do so, click on Add backup button. Click on folder button to browse for the backup file with file explorer:

In case that the Scan folder option is selected, it is required to specify a folder path, and optionally to add a filename pattern, and include subfolders:

The Restore type is selected in the same tab. Depending on the available backup files, select one of the three restore types:

  • Full
  • Full and differential
  • Full, differential and transaction log

Choose to run this restore backup job immediately or schedule it to run at a desired time by clicking on Schedule radio button in an already described manner.

In the Advanced tab of the wizard, it is possible to specify locations for the data and log file folders, as well as the post-restore database verification. If needed, a custom script can be run after the restore operation. The script command can be inserted in a text box at the bottom of the form:

Again, to be notified on job completion, head over to the Notification tab and add email recipients:

Click Finish at the form bottom to execute or schedule the job:

In order to schedule a log shipping job with ApexSQL Backup, click on the Log shipping button in tasks group:

In the main tab of the Log shipping wizard, specify the following:

  • Select a SQL Server that hosts a database used as a source
  • Select a database that will be used as a source
  • Select a local folder that will be used as a storage
  • Select a network location, the path to a shared folder accessible by both primary and secondary server:

Click on the Add button to bring up the Add destination setup dialog and specify the following:

  • Select a SQL Server that hosts a database used as a destination
  • Select an existing database that will be used as a destination, or enter a name for a new database that will be created during a restore job
  • Choose a recovery model
  • Select a local folder that will be used as a storage for copied backups and undo files

By default, the box for the Custom location for data and log files option is unchecked. When checked, the options for the custom data and log file locations are available:

Click the OK button to close the dialog:

To add more destination databases, click on the Add button again, and repeat the previously described steps.

Under the Schedule area, both backup and restore jobs can be scheduled by clicking on the schedule browse button in an appropriate field:

In the Add schedule for both backup and restore jobs, the user needs to specify when, and how often the job will occur:

Choose to be notified, upon job completion, in the Notification tab of the wizard. Afterwards click on the Finish button to execute or schedule the log shipping job:

To schedule an index reorganize or rebuild job with ApexSQL Backup, in the Home tab, click on Reorganize/Rebuild index buttons respectively from the Tasks group:

Provide SQL Server and database details, choose tables and views to be included in the defragmentation job:

To provide schedule details, click on the Schedule radio button, and choose schedule frequency and duration, and then click on the OK button:

To complete the schedule, click on the Finish button:

All those backup/restore and log shipping jobs are now listed under the Activities tab, where they can be deleted, filtered by result or exported to CSV, XML, HTML or PDF file formats. To export activities, check any number of listed ones and click on the Export button in the Activities group where export file formats are listed:

Immediately upon saving the file you will be asked to open it. The end result will look like this:

Under the Schedules tab, scheduled jobs are listed with details, where they can be further edited, deleted, enabled or disabled:

Under the History tab we can get a detailed backup history for any database in a visual timeline format. You get a different color for full, differential and log backups. You can hover the mouse on the timeline to get the start and end time of any particular backup:

Thanks for watching. For more information, please visit apexsql.com