How to backup Azure SQL Database to Local Machine
Even though Azure SQL Database provides built-in backup, you may still want to create a local copy of your Azure SQL database. […]
Tag: sqlbackupandftp
How to solve Operating system error 3
When using SQLBackupAndFTP you may have come across this SQL Server error when saving a database backup: Cannot open backup device ‘<Path\Filename>’. […]
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 […]
SQL Server Copy-Only Backup
For 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 […]
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 […]
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 […]
How to backup SQL Server to UNC Path
If you have limited access to SQL Server’s file system, getting the .bak file back may be an issue. In this case, […]
How to backup multiple servers
This article is an easy step-by-step tutorial and it will explain how to easily backup multiple servers and the databases that you […]
Learn the Ways to 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 […]
Cannot perform a differential backup because current backup does not exist
“Cannot perform a differential backup for database, because a current database backup does not exist” is not a common error, which is […]