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 and choosing “Add New Backup Job” or click “Job” > “Add New Backup Job”.
- After creating this new job you must first connect to the database server 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 your Server Type (DBMS). Then specify the Server Name and input the required User name and Password in order to connect to the server instance. Assume you are going to connect to your local SQL Server.
- If the connection was successful the name of the database server should appear in the “Connect to Microsoft SQL Server (local)” section.
- 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 that we recommend.
After completing all of the details of your job we recommend testing 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.