No Backupset Selected to be Restored

Let’s imagine the following situation. You have SQL Server database and you perform backups from time to time. Something went wrong and now you need to restore your SQL Server database. You start to do it with the help of SSMS (SQL Server Management Studio) but face with the following error message: “No Backupset Selected to be Restored“.

Read more

How to Backup Database SQL

If you are looking for a way how to backup database SQL, then you can use SqlBak. SqlBak is a simple tool that will make SQL Server database backups and sends them to the selected destination. All you need is to spend a few minutes and create a SqlBak backup job. This backup job will do all the backup work for you. In this topic, we are going to discuss how to backup database SQL and what actually is SQL Server backups. 

Read more

Backup and Recovery Best Practices

If you are looking for backup and recovery best practices, then this article is for you. The best and the easiest way to backup and restore your databases is to use SqlBak. If you are reading this article, it means that you already know the crucial role of SQL Server database backups. Scheduled backups are the best way to protect your SQL Server database from the disaster. Bellow, you can find a shortlist of backup and recovery best practices.

Read more

What is Differential Backup

In this blog post, we are going to discuss what is a differential backup and how to perform a differential backup with the help of SqlBak. It is well known that you can perform SQL Server database backups with the help of T-SQL Commands and SSMS (SQL Server Management Studio), but the easiest way to make full, differential, and transaction log backups are to use SqlBak. So let’s start from the definition of what differential backup is?

Read more

Schedule Backup SQL Server 2008 R2

If you are looking for a way to make schedule backup SQL Server 2008 R2, then use SqlBak. This simple tool will make SQL Server database backups according to your schedule. Nowadays, there are three most common ways to make schedule backup SQL Server 2008 R2. You can create SQL Server backups with the help of T-SQL Commands or use SQL Server Management Studio. But the easiest way is to us SqlBak. All you need is a few minutes to create a SqlBak backup job. The backup job will make a schedule backup SQL Server 2008 R2.

Read more

SQL Server Backup Schedule

You need to create SQL Server backup schedule with the help of SqlBak to keep your database safe and sound. From the beginning, let’s discuss what a backup is? Quite frankly talking, a database backup is a representative duplicate of data. When you lost your backups, you can use the backup to rebuild destroyed records. It duplicate contains crucial elements of your database, such as the managed file, archive logs, and datafiles-structures described later in this section. In the occasion of a media failure, your database backup is the key to properly recovering your information.

Read more