Tag Archives: sqlbackupandftp

How to set up SQL Server Email Job Notifications

As a DBA, automating your various jobs on SQL Server – taking backups, truncating logs, updating statistics, etc – is a good idea because it makes sure you don’t have to depend on your feeble memory for these important tasks. And it leaves you free for more vital tasks such as sleeping and bingeing on whatever new Netflix series is out. But to make sure your automated tasks are still running, you need a good notification method, and it should also be automated. And foolproof. So how do you do this? Continue reading How to set up SQL Server Email Job Notifications

SQL Server Copy-Only Backup

duck_familyFor many DBA’s, copy-only backups introduced in SQL Server 2005 are a little-known and little-used feature of SQL Server. However, they can be mightily useful whenever you need ad hoc backups and do not want to interrupt and mess up your existing backup schedule. Read on to find out more.

Continue reading SQL Server Copy-Only Backup

How to set up Cloud-based Storage for SQL Server Backup

A central tenet of Disaster Recovery (DR) is that you should always maintain an offsite or off-premises copy of your critical database backups. The logic behind this is simple – if you don’t have access to your premises, for example in case of a natural disaster affecting your area, your offsite backups mean that you can restore them and still have access to your critical data. Let’s take a more in-depth look at cloud-based storage for your SQL Server backups. Continue reading How to set up Cloud-based Storage for SQL Server Backup

RESTORE VERIFYONLY and CHECKSUM options

For any SQL Server DBA who’s been in the field for a long time, you know that the exercise of restoring backups taken in SQL Server 2000 (and even SQL Server 2005 without using the CHECKSUM option) was many times a sweat-filled lottery. You usually gambled and/ or prayed to your respective deity that your backups would actually work. Why? Because you knew that restore failures were all too common. Despite SQL Server’s assurance that all was well because you had already verified your backups with the RESTORE VERIFYONLY option. So why was this the case? Why did restore operations fail so frequently? Let’s delve a bit more into the innards of the RESTORE VERIFYONLY and CHECKSUM options to find out.

Continue reading RESTORE VERIFYONLY and CHECKSUM options

How to backup to UNC Path

backup to unc pathIt’s important to have flexibility and not sacrifice security when backing up your databases. For this reason, some DBAs will prefer to backup to UNC paths on their local network.
This will keep the backups in a closed environment with access only to those users inside the network which are authorized.
In this article we will show you how to backup to UNC paths in the simplest way possible, by using SQLBackupAndFTP, instead of using complex and confusing T-SQL and complex maintenance plans.

Continue reading How to backup to UNC Path

Learn the Ways to Recover MySQL Root Password without Restarting

Recover MySQL Root Password without Restarting
When you are using the master production server and there appears a need to recover the root password in MySQL, you cannot restart at once. The remote database experts suggest the few ways by which you can come out of this situation.

Click to read the article and to find out how to resolve this!

Continue reading Learn the Ways to Recover MySQL Root Password without Restarting

Cannot perform a differential backup because current backup does not exist

cannot perform a differential backup
Cannot perform a differential backup for database, because a current database backup does not exist” is not a common error, which is why you might have a hard time finding a solution or an answer to it.
This is why we have written an article to explain why this is happening and how to resolve this problem.
Click to find out more details!
Continue reading Cannot perform a differential backup because current backup does not exist

Backup SQL Server Database from command line

backup SQL Server Database from command lineOne of the most important operations and tasks that need to be performed on a database is the backup process.
In this sense you can prompt to backup a SQL Server database from the command line using SQLBackupAndFTP with some additional parameters, which are also passed in the command terminal.
Continue reading Backup SQL Server Database from command line