SqlBak.com presents you a free SQL Server backup types cheat sheet infographic. This cheat sheet clearly explains the difference between Full Backup, Differential Backup and Transaction Log Backup in SQL Server. Feel free to Download PDF or PNG files.
A cold database backup is when you make a simple copy of the data and log files. For this to work, the database should be taken offline first.
This is the opposite of the hot database backup that is the regular backup performed while the database is in use. In SQL Server it is usually done with the BACKUP DATABASE command.
In this article, we will talk about how to backup query results if you are using a database querying application like SQL Server Management Studio.
We will cover multiple possibilities of backing up your results, from those built-in SSMS (SQL Server Management Studio) to some workarounds we consider to be more efficient.
Continue to read to find out how to achieve this…
Encountering a “Cannot perform a differential backup for database, because a current database backup does not exist” error might generate some confusion if you look into your backup log and can see that FULL backups have been successfully created.
This blog article will show you how to silently install SqlBak App on your machine.
We will also explain what is a silent installation and why it could be useful for you when choosing to install SqlBak App on your database machines.
In order to backup a SQL Server to a NAS drive, all you need is to use SqlBak.
Backups are very important, and many organizations have different standards and rules for storing backups, from the more constrained from a security point of view which require you to store them locally (on-premises) to the organizations that allow their DBAs to store backups of their databases onto cloud storage services.
For those organizations that choose to store their backups locally, there are multiple storage solutions, one of which is owning your own NAS.
In order to organize the types of backups you make from your databases, you have multiple options when using SqlBak.
If you want, for example, to store FULL SQL Server backup on Amazon and differential backups to your FTP folder, SqlBak allows you to do this.
In the below article, we will show you how to do this, fairly easily, through the Task Schedule screen.
It’s important to verify SQL Server backup files after the backup process is complete.
Although the process can finish successfully this does not guarantee that the integrity of the data in the backup file is valid.
This will definitely cause some annoyance when later trying to restore the backup file.
In order to avoid this unwanted scenario, you should use verification options …
SQL Server maintenance is just as important as creating backups of your databases.
Unfortunately, there are many companies out there that install a SQL Server database or more without setting up first their maintenance plans.
Everything is perfect as usually at the beginning there is no problem, that is until a problem appears.
Restoring a SQL Server database from a Differential or Transaction log backup can’t be simpler when using SqlBak.
All that you have to do is press a few buttons and the restore operation will be complete. Read the article to find out how.
