SQLBackupAndFTP's blog
Effortless SQL Server backups
  • Our Product
  • Features & Prices
  • Download
  • Purchase
  • Forum
  • Support
August 21, 2020

How to automate maintenance of your databases

Maintenance of your databases is as important as regular backups. Once scheduled backups are set, the thought may appear that your data is safe and sound and it is, until a problem appears.

As a rule, databases don’t crash completely, but there may be a sharp decrease in performance because of server laсk of disk space or any other issues that can corrupt databases. That’s why it’s highly recommended not only to perform regular backups of your databases but also maintain them. More…

May 1, 2020

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
    • Via AWS ManagementConsole
    • Via AWS CLI
  2. Native backup to S3
  3. Export bacpac\dacpac
    • Via SSMS (SQL Server Management Studio)
    • Via SqlPackage
  4. Via SQLBackupAndFTP

More…

April 10, 2020

Scheduled Restore. How to set up Log Shipping

Log Shipping is SQL Server technology that is available in Standard/Enterprise editions. The technology may be useful in solving the following problems:

  1. Creation of read-only servers to perform heavy SQL queries and reduce the load on the primary server
  2. Creating backup servers that can be quickly put into operation in the case of a primary server failure
  3. Creating a server with data, that lagging in relevance from the primary server for a given time interval

More…

March 10, 2020

[JOB-BAK:1301#1] Failed to backup database. There is no destination selected to keep Full database backup type

If you get the following error message during a backup:

[JOB-BAK:1301#1] Failed to backup <database name> database with "Full" backup type: Failed to backup <database name> database. There is no destination selected to keep Full database backup type. More...
March 4, 2020

[DST-1:1003#53] The network path was not found

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

More…

March 2, 2020

[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'.

More…

February 26, 2020

Solved: [JOB-BAK:2006#11008] Previous Full backup of a database was created with a different application

During the backup you can face the following warning:

[Warning] [JOB-BAK:2006#11008]. The previous full backup of <database name> database was created with a different application (non-SQLBackupAndFTP). You may not able to restore the database automatically using SQLBackupAndFTP.

More…

January 22, 2020

How to increase timeout values

In rare cases, some operations in SQLBackupAndFTP don’t fit standard timeouts and fail. For this reason, in version 12.3.3 we added a possibility to define custom timeout values by creating C:\ProgramData\Pranas.NET\SQLBackupAndFTP\Service\Timeouts.xml with the following contents: More…

September 6, 2019

Setting Windows PATH for Postgres tools

If, after installing PostgreSQL, you face “psql not recognized as an internal or external command” error when you try to run psql from command prompt, then most probably all you need to do to solve this problem is to add the Postgres’s bin directory to the PATH system variable (the PATH is a system variable which allows Windows with the help of the Command prompt or the Terminal window find executables).

In this blog post, we’ll share seven simple steps that describe how to add the folder to the Windows 10 PATH variable.

More…

August 5, 2019

How to Backup PostgreSQL to Amazon S3

How do you make your PostgreSQL database backups, with the help of pg_dump utility or in any other way? Do you prefer to store your backup in the cloud, like Amazon S3? How much time do you usually spend every day to make your database backup and send them to Amazon S3? It is really very easy to backup PostgreSQL to Amazon S3 with the help of SQLBackupAndFTP. You can create a backup job just in a few minutes. More…

1 2 3 4 5 >»

Support button

?

↑

© SQLBackupAndFTP's blog 2021
Powered by WordPress • Themify WordPress Themes