Configure a Microsoft SQL database backup

Use this article to back up your Microsoft SQL databases.

  1. Log on to the server and launch Synergize EMC.

Graphical user interface, Teams

Description automatically generated

  1. Survey the Deployment Profiles to obtain the names of the Synergize databases.

Synergize Databases are usually set with the name of the Deployment Profile and the Repositories.

Graphical user interface, text, application, email

Description automatically generated

2. Log into Microsoft SQL Server Management Studio and expand the Databases node. Right-click on the appropriate Synergize database then using the Tasks submenu select Back Up.

Graphical user interface, application

Description automatically generated

3. Using the Back Up Database window set a Backup type then using the Add button set an output directory for the backup. Ensure the file type is bak.

Graphical user interface, application

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

4. Under Media Options set a Overwrite media method. Configure other fields options at your discretion.

Graphical user interface, text, application, email

Description automatically generated

5. In the Backup Options name the backup set. Using the arrows set a Backup set will expire interval. Once this time elapses the backup can be overwritten.

Configure other fields at your discretion. Click OK when finished.

Graphical user interface, application

Description automatically generated

See also https://msdn.microsoft.com/en-us/library/ms187510.aspx