Category Archives: amazon

amazon

How to backup and restore Amazon RDS SQL Server

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:

  1. Snapshot creation
  2. Native backup to S3
  3. Export bacpac\dacpac
  4. Via SQLBackupAndFTP

Continue reading How to backup and restore Amazon RDS SQL Server

[DST-1:1001#103] Destination error: Could not find a part of the path

Typically, the following error message:

Destination error: Could not find a part of the path 'y:\1'.
Trying again...
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

How Tos – SQLBackupAndFTP

Licensing

Database Backups

Backup Storages

Database-related settings

Security & Reliability

Errors

Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

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

How to Make SugarCRM Backup

sugarcrm logoToday 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