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 which will make all backups according to your schedule less than 2 minutes.
How to Backup SQL Server to Local or Network Folder
Follow this simple steps to create a backup job which will make scheduled backups of your SQL Server databases and send them to Local or Network Folder.
- First of all, you need to download, install and connect SQLBackupAndFTP to your SQL Server. Then 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”. Set all configuration 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”.