How much time do you usually spend to make your SQL Server database backup? Is your method convenient and reliable? Assume that your need to perform full backups every 24 hours, differential backups every 6 hours, and transaction log backups every 30 minutes. How much time would you spend if you prefer to make SQL Server database backups with the help of T-SQL Commands or SSMS? You can simply use SQLBackupAndFTP to create a backup job that will make all backups according to your schedule in less than 2 minutes.
How to Backup SQL Server to Local or Network Folder
Follow these simple steps to create a backup job that will make scheduled backups of your SQL Server databases and send them to the Local or Network Folder.
- First of all, you need to download, install and connect SQLBackupAndFTP to your SQL Server. You can do it at the “Connect to Database Server” section by clicking the “gear” button. In the opened window choose your server type, specify its name, and set the credentials, after that click on the “test” button to check the connection.
- Now it’s time to select the databases that should be backed up. To do it click the gear button at the “Select databases” section and choose all databases which you are going to backup from the list.
- To select destinations where you are going to store the backups, click the plus button at the “Store backups in selected destinations” and choose “Local/Network Folder/NAS”.
Set all configurations and specify a folder where to store SQL Server database backups. Press “Test” to check the connection. To save all settings click “Save & Close”.
- To create a backup schedule turn on “Schedule backups” and click the gear button to find “Advanced backup schedule”. Set up the settings you need and press “Save & Close”.
- Now all settings are done and you can run your backup job immediately by clicking “Run Now”.