SQL Express: backup plan

Introduction

With the SQL Express version, it is not possible to set up a backup plan using SSMS.

There are many scripts on the Internet for performing a backup, in this tutorial I will explain how to put in backup plan with a SQL Backup Master that is available for free.

The installation of the software is very simple, I do not detail it in the article.

Creating a SQL Express backup plan

Run SQL Backup Master using the shortcut that was created on the desktop during installation.
SBM

Once SQL Backup Master is open, click Create new database backup 1 .
Create backup

Click on Choose SQL Server 1 .
Select server

Select a connection method 1 then click on Test SQL Connection 2 .
Configure logon server

If the parameters are good, a message is displayed indicating that the connection is established, close the window by clicking OK, then validate the connection parameters by clicking OK. On the left side of the SBM the available databases are displayed, select the databases to be saved 1 and click on Add 2 to specify the location.
Select databases

Several types of support are available, some require a license and are not available in the free version. Click on Local or Network Folder 1 .
Destination type

Enter the backup destination 1 , in the case of a network share it is possible to specify a 2 account. Set the expiration time of a backup set 3 and click OK 4 .
Folder settings

Now you have to configure the schedule, click on Not scheduled 1 .
Configure schedule

Configure the schedule according to the backup type 1 and click Save 2 .
Schedule settings

Name job 1 and click Save 2 .
Save job

The job is added, the databases will be saved every day at 11am. You can trigger a manual backup by clicking the Back up now button.
Job added


SQL Backup Master is an alternative to scripts to perform database backups in SQL Express by approaching a maintenance plan as one could do with SQL Server Management Studio.



Related Posts


Veeam Agent 3 for Windows: Installation and Configuration
The Veeam Agent allows physical or virtual computer backup directly from Windows unlike Veeam Backup & Replication which manages the backup of virtual machines from the Hypervisor (VMware, Hyper-V). Version 3 of the agent is available since Janua

Veeam – extracting a backup with the Export Backup
Introduction With version 9.5u4, a new feature has been added to Veeam which is the Export Backup. The export backup is used to extract (export) files from a backup, a restore point of a virtual machine. This feature can, for example, make it possibl

MDT: saving user profiles with USMT
Introduction In this article, we will have how to back up user profiles with MDT during a deployment. Use of this feature is useful in the following cases: Change of computer of a user. Reinstalling the computer Upgrade version of Windows. To save th

Leave a Comment