Category Archives: restore

restore

Scheduled Restore. How to Set Up Log Shipping

backup history, restore, SQL Server

Log Shipping is SQL Server technology that is available in both the Standard and 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 secondary (slave) server, where data is updated with a fixed delay

Continue reading Scheduled Restore. How to Set Up Log Shipping →

MySQL Auto Backup

MySQL Server, restore, sql backup job

If you are looking for a MySQL auto backup tool then you can use SQLBackupAndFTP. It is really crucial to make MySQL backups on a regular basis. Do you really have to make MySQL auto backup and recovery? Sure. Unless you don’t care about your data or you are okay having to completely recreate your database in the event of a disaster, you need some way of restoring the database to a workable point. There are several ways how to perform MySQL Server backup and recovery, but the quickest is to use the SQLBackupAndFTP application. Continue reading MySQL Auto Backup →

PostgreSQL Backup is Discontinued

backup history, restore, use cases

Thank you for using PostgreSQL Backup. Unfortunately, it is discontinued and we do not plan to develop it going forward. While you can still use it on your own we strongly recommend migrating to our newest product SQLBackupAndFTP. It can do everything PostgreSQL Backup was able to do, plus it can restore PostgreSQL backups in a couple of clicks, show backup history on the web, send alerts when your server is down, and much more…

MySQLBackupFTP is Discontinued

backup history, restore, use cases

Thank you for using MySQLBackupFTP. Unfortunately, it is discontinued and we do not plan to develop it going forward. While you can still use it on your own we strongly recommend migrating to our newest product SQLBackupAndFTP. It can do everything
MySQLBackupFTP was able to do, plus it can restore MySQL backups in a couple of clicks, show backup history on the web, send alerts when your server is down, and much more…

Get SQLBackupAndFTP

PowerShell how to backup and recover an SQL Server database FAQ

Database Backup, restore, SQL Server

The following article will explain how to backup and restore databases in SQL Server using PowerShell. PowerShell is a very popular shell for operative systems used to automate tasks using the command line and scripts. PowerShell was created by Microsoft in Windows, but now it is supported in Linux and macOS also. Continue reading PowerShell how to backup and recover an SQL Server database FAQ →

This BACKUP or RESTORE command is not supported on a database mirror or secondary replica

adventureworks, restore, SQL Server

During the backup process, you can get different error messages, it doesn’t matter how you make SQL Server database backups. You can backup your database using T-SQL Commands, SSMS or SQLBackupAndFTP. Assume during the backup process, you receive the following error message:  Continue reading This BACKUP or RESTORE command is not supported on a database mirror or secondary replica →

Backup and Restore Utility SQLBackupAndFTP

differential, MISC, restore

In that blog post let’s talk about one of the crucial questions in the life of every DBA it is SQL Server database backup and restores process, which you can cover using backup and restore utility SQLBackupAndFTP. You can install this tool on your machine or personal computer and it will do all work for you. So here is a short tutorial how you can protect your SQL Server database using backup and restore utility. Continue reading Backup and Restore Utility SQLBackupAndFTP →

Backup And Restore SQL Database

database, MISC, restore

If you are looking for a tool to backup and restore SQL database then use simple tool SQLBackupAndFTP. The most typical jokes you’ll discover when mentioning about one particular important responsibility for a DBA goes like this – a Database Administrator requires one of two things, a great backup or an ideal resume. It’s real. If you’re not performing backups and making sure that you can recover databases from those backups, you’re exposing yourself and your company to information loss. Continue reading Backup And Restore SQL Database →