Amazon RDS SQL Server is a cloud database from Amazon, one of its differences from classic SQL Server is the way it performs backups. RDS SQL Server does not support the T-SQL BACKUP DATABASE construction but instead offers several other approaches such as restore point-in-time, snapshots, native backup to S3, and Export Data-tier Application.
Here are ways to perform a backup and restore:
- Snapshot creation
- Native backup to S3
- Export bacpac\dacpac
- Via SQLBackupAndFTP
Continue reading How to backup and restore Amazon RDS SQL Server
If the following error message happens:
[DST-1:1003#53] Destination error: Failed to open "\\networkpath\backupfolder" destination connection. > The network path was not found
Continue reading [DST-1:1003#53] The network path was not found
Typically, the following error message:
Destination error: Could not find a part of the path 'y:\1'.
Destination error: #[DST-1:1001#103] Failed to connect to the Folder destination. > Failed to create folder "y:\1". > Could not find a part of the path 'y:\1'.
Continue reading [DST-1:1001#103] Destination error: Could not find a part of the path
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
SQLBackupAndFTP is a standalone application. Once you have purchased a license, it never expires and you can use the version you’ve purchased forever. The Full-Service subscription is a set of important, but optional services and it requires a recurring annual fee (see prices).
Continue reading Why do you need the Full-Service subscription?
SQLBackupAndFTP 11 is significantly different from the previous versions – see the detailed post on what is new in v11. Here you can get a birds eye view on what is new and what is missing in the new version.
Continue reading How SQLBackupAndFTP 11 differs from the previous versions?
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?
The best way to backup your SQL Server databases is to use SQLBackupAndFTP. But if you still backup your SQL Server database with the help of SQL Server Management Studio you can face the following issue. Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512. Before solving this case let’s recreate the same error message. Continue reading Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512
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