Shulou(Shulou.com)06/01 Report--

This article introduces the knowledge about "how to automatically perform database and folder backup on Windows Server". In the actual case operation process, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to handle these situations! I hope you can read carefully and learn something!

introduced

The importance of providing automatic backup policies for servers is a necessity.

Every server administrator has to do the heavy lifting of setting up backups, including scripting, scheduling tasks, setting alerts, and so on.

To simplify this task, I share a utility to help server administrators and database administrators automate backups. This utility automatically performs MSSQL, MySQL, and folder backups.

This is an open source project hosted on GitHub and can be downloaded from:

https://github.com/runtimesoftware/runtime-backup-manager

Part 1-Installation Utility

Download the installation file from the GitHub repository (Installer\bin folder)

Install on servers where backups need to be set up

After running the application, you will see the following screen:

Part 2-Defining Backup Jobs

Click the Settings button in the lower right corner to configure the backup job.

On the first tab, MSSQL Server, click the Add button to add a new MSSQL backup.

Define server details as follows. Check Enable Backup and specify the backup time.

After entering the details, click Verify and Save.

The tool will attempt to connect to MSSQL server using the given credentials.

If the connection is successful, the entry is saved and you will see it in the list, as shown below,

Similarly, go to the second tab, MySQL Server, and click the Add button to add MySQL backups.

You can also use the Folder Backup tab to back up specific server folders.

Part 3-Specify Local Storage Locations

After defining the backup job, go to the Local Storage tab and specify the folder on the server where you want to store the backup.

Note that this folder should not be one of the backup folders, otherwise the program may behave unexpectedly.

Since all backups will be stored in this folder, it is recommended that you set an auto-delete policy as shown above.

You can set a longer duration, such as 15 days or so, depending on your convenience.

Part 4-Remote Storage

After backing up files locally on the server itself, we need to move them to remote storage.

Currently, the utility supports amazons3 backups. Go to the Remote Storage tab and define AWS credentials to automatically move files from Local Storage to Remote Storage.

You can also select the option to automatically delete files as soon as they are uploaded to AWS S3.

Click Verify and Save to check that the credentials you entered are valid for writing to the AWS S3 bucket.

Part 5-Email Alerts

You can easily set up email alerts to notify successful/failed backup jobs (local and remote)

Click the Email Settings tab and define your SMTP credentials as shown below.

There are four types of alerts available:

Send mail when local backup fails

Send mail when remote backup fails

Send mail when local backup is successful

Send mail on successful remote backup

Click Verify and Save to check your email credentials. This sends a test message to the To Email address.

Click Close to return to the Home screen.

The number of defined backups is displayed here. It will also show the status of AWS S3 settings and email settings.

Click the Install button to install backup services so jobs can be processed in the background.

This may take a few seconds. The state will change as follows:

To view the log, click the Log button. Here you can find logs and results of backup jobs for troubleshooting.

After that, you can click Exit to close the user interface.

The backup service will continue to run in the background and will be responsible for defined backup jobs.

To verify the backup service status, open 'Service.msc' and check the service name 'Runtime Backup service'

The following is an example of an email sent by the utility:

"How to automatically perform database and folder backups on Windows Server" is introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.