This post will give you a bird’s eye view explanation of what “cloud database” is and what kinds of cloud databases the market offers us today. Continue reading Cloud Databases for Busy People
Here we tried to answer the most asked questions. If you couldn’t find an answer here you can ask your question on the community forum. If you have an active Full-Service subscription you can contact support.
Have you seen our brand-new version 11 of SQLBackupAndFTP? If yes, then you have also noticed that its looks and feels very different from its predecessor (compare features in the new & old versions). That’s right – this release is built from scratch based on our eight-year experience creating SQL Server backup software and close to 1,000,000 installations of the previous versions.
If you have used the old version, this post will help you to quickly grasp the main points that make the new version better. If you are new to SQLBackupAndFTP, you can read this as a quick introduction. Continue reading SQLBackupAndFTP v11 – What’s New?
- How to Backup SQL Database Automatically
- How to Backup SQL Server 2016
- How to backup multiple servers
- How to specify backup’s lifetime
- How to remove old backups
- How to lower the priority of 7-zip process
- How to Backup SQL Server to FTP Server
- How to backup to UNC Path
- How to backup a SQL Server database to NAS drive
- How to Backup SQL Server to Local or Network Folder
- How to Backup SQL Server to Azure Storage
- How to Backup SQL Server to Amazon S3
- How to Backup SQL Server to OneDrive
- How to Backup SQL Server to Dropbox
- How to Backup SQL Server to Google Drive
- How to save SQL Server backups to Azure
Security & Reliability
- How to get SQL Server backup Email Notification
- How to verify backup files after backup
- How to perform SQL Server maintenance
- How to encrypt SQL server backups
Have you been asking yourself what kind of storage is the most appropriate for keeping your database backup? While there is no 100% perfect answer, in this blog post we are going to share with you some statistics that may help you in this matter. Continue reading Where Do People Prefer Keeping Their SQL Backups?
Sometimes when you backup your SQL Server using SQLBackupAndFTP, SSMS or T-SQL Commands you can face the following issue Cannot Open Backup Device Operating System Error 5(Access is Denied). This has to be the most famous issue in taking SQL Server database backups. There are several reasons for this error and there are various ways to solve it. Some time ago we met this issue and for a time we were creating a backup and discovered a very helpful resolution to the issue. The issue was as described beneath:
Msg 3201, Level 16, State 1, Line 4 Cannot open backup device 'D:\Adventureworks.bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 4 BACKUP DATABASE is terminating abnormally.
While it’s easy to create SQL Server Express backup with SQL Server Management Studio it’s quite difficult to run it regularly since SQL Server Express edition lacks handy job scheduler maintenance options in comparison with the full version of SQL Server. Here is where third-party backup utilities like SQLBackupAndFTP enter the stage. Continue reading SQL Server Express Backup
Today over 50,000 companies use SugarCRM globally for their customer management, sales automation, and other CRM needs. SugarCRM can be installed as an on-premise solution or as a SaaS (Software-as-a-Service) solution. Managing SugarCRM means that you have to work with a huge flow of information that is stored in large databases. Clearly, when working with databases one has to take care of their security, and that implies making backups on a regular basis. Now let’s check how to use SQLBackupAndFTP for regular SugarCRM backups.
Continue reading How to Make SugarCRM Backup
If you have limited access to SQL Server’s file system, getting the .bak file back may be an issue. In this case, you can send database backup to some network folder if both you and the SQL Server have access to it.
We will show how to do it with SQLBackupAndFTP. Continue reading How to backup SQL Server to UNC Path