How to connect to MySQL Server using SSH key pairs
To backup MySQL Server via SQLBackupAndFTP, you have to establish a connection via TCP/IP. In other words, SQLBackupAndFTP connects to a database […]
Command Line Arguments to Manage an Installation
Assume you need to clone your server and you have an image, for example, an AMI (Amazon Machine Image) in AWS with […]
Automating SQL Server backups on Windows: why you need it and how to do it
A backup is a copy of data taken and stored elsewhere so that you can restore it in case of a database […]
How to Set Up Log Shipping
If there is a need to synchronize databases on your primary server with databases located on your secondary server, then log shipping […]
How to automate MySQL Database backups in Windows
Preservation of data is an essential part of any business. Losing a database, such as a customer list, could effectively be the […]
How to clone SQL SERVER database to a Test Environment
It doesn’t matter if a company is large or small, almost every database administrator needs to maintain a copy of the production […]
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 […]
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 […]
Scheduled Restore. How to Set Up Log Shipping
Log Shipping is SQL Server technology that is available in both the Standard and Enterprise editions. The technology may be useful in […]
[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 […]