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.
Tag Archives: sql server
SQL Server backup report
Sometimes it helps to have simple access to detailed information about your latest backups.
This is why a backup report always comes in handy when you need to know when was the last time your database or a specific database was backed up and what was the last type of backup that was taken.
In order to help you with this, we’ve composed a small script which you can easily run to find out important information.
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, you can send database backup to some network folder if both you and the SQL Server have access to it.
We will show how to do it with SQLBackupAndFTP. Continue reading How to backup SQL Server to UNC Path
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 want while using SQLBackupAndFTP.
Backup SQL Server Database from command line with SQLBackupAndFTP version 10 or earlier
One 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 version 10 or earlier with some additional parameters, which are also passed in the command terminal.
Continue reading Backup SQL Server Database from command line with SQLBackupAndFTP version 10 or earlier
How to backup a SQL Server database to NAS drive
Backing up your database is one of the most important tasks a DBA should have set. There are multiple options in terms of backing up a database, for instance, you could backup a SQL Server database to NAS drives.
If you prefer this option or if your organization requires you that you backup your databases on your local network then you can count on SQLBackupAndFTP to assist you with this and make the job much easier!
Continue reading How to backup a SQL Server database to NAS drive
How to verify SQL Server backup files after backup
One of the most often made assumptions is that if you have made a backup of your database, your data is safe.
Unfortunately, this is not true, and I’ll explain why, but don’t forget to verify SQL Server backup files after backup!
SQLBackupAndFTP allows you to do this, in order to be absolutely sure that indeed, your data is safe!
Continue reading How to verify SQL Server backup files after backup
How to perform SQL Server maintenance
How to encrypt SQL server backups
Make sure to encrypt SQL Server backups in order to add another level of security to your data.
Adding this option to your backups is extremely easy with the help of the Encryption option in SQLBackupAndFTP.
Read the short tutorial in this article below to encrypt your backups.
Continue reading How to encrypt SQL server backups
How to get SQL Server backup email notification
Continue reading How to get SQL Server backup email notification