How to Backup SQL Server to Local or Network Folder

How to backup SQL Server to Local or Network Folder (logo)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.

  1. 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. How to Backup SQL Server to Local or Network Folder (Select database)
  2. 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”. How to Backup SQL Server to Local or Network Folder (destination place)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”.How to Backup SQL Server to Local or Network Folder (Folder Settings) copy
  3. 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”.
    How to Backup SQL Server to Local or Network Folder (backup schedule)
  4. Now all settings are done and you can run your backup job immediately by clicking “Run Now”.  How to Backup SQL Server to Local or Network Folder (Run Now)
[Total: 3    Average: 5/5]

Leave a Reply

Your email address will not be published.