How to backup multiple servers

This article is an easy step by step tutorial and it will explain how to easily backup multiple servers and the databases that you want, while using SQLBackupAndFTP.
 

Backup multiple servers

In order to backup multiple servers with SQLBackupAndFTP, all you have to do is create a new job for each server that you want to backup databases from. Thus if you want to backup 3 servers, you will have to create 3 jobs.

Below we will try to exemplify what are the generic steps you should take to backup multiple servers with SQLBackupAndFTP.

    • You start SQLBackupAndFTP and create a New Job by pressing the plus button (as displayed below).

SQLBackupAndFTP create a backup job

    • After creating this new job you must first connect to the database server (SQL Server Instance) in order to have access to the databases which are going to be backed up. A smaller window will appear automatically where you will have to select the Server Name you want to connect to, from the drop-down list. Input the required User name and Password in order to connect to the server instance.

Connect to SQL Server on this computer

    • If the connection was successful the name of the database server should appear in the “SQL Server” section.

SQLBackupAndFTP SQL Server

    • The list of databases available on this server will be displayed after you click the gear button. Select which one you want to back up.

Also, do not forget that the process is not yet complete without selecting an appropriate Backup Location, setting a Schedule for this Backup plan and other best practices which we recommend.

After completing all of the details of your job we recommend to test the job by pressing Run Now. If the job runs successfully and if the backup file is created correctly then everything is finished.

All you have to do now is to press the “New Job” button and restart the process from the second step and continue this workflow until you have created backup jobs for each of the servers you want to back up.

If you have any questions or problems please feel free to post a comment on this article or visit our Forum.

[Total: 1    Average: 5/5]

About Radu Gheorghiu

Passionate SQL Developer on the journey of trying to become an expert in all things Data (storage, manipulation, gathering etc.) Information is power, and information can only be obtained from data. Thus, in order to harness the power of information, you must be a master of Data.

Leave a Reply

Your email address will not be published.