You’ve recently come across a peculiar type of file with a .bak extension, and you know you are supposed to restore it in order to get the data.
This article will show you what to do in case you have such a file, and you need to open it to access the information.
We already know that backups are important for securing your databases from data loss.
We also have an article about best practices regarding backups, but the article is quite detailed and if you want to take a shortcut and take care of the essentials, then you’ve found it here.
If you encounter the error message, “the media family on device is incorrectly formed. SQL Server cannot process this media family,” you may not initially understand exactly what happened.
This post will try to give you a few suggestions as to what might have gone wrong and what to do in those situations.
If you’re here, then there’s a high chance you already know the importance of good backups and what they mean to a serious business.Now that we know how SQL works in a database system, it is now time to learn what sql commands (code) we need to write for specific operations.
As we said in our previous post, SQL gives you complete power over your data. But what does this mean exactly? We have many types of commands which allow you to do different operations with your data.
Now that we know how the database system works, and how data is retrieved from the database, it would be time to understand how is data stored in a database.
Inside a database, data is stored into …
What would a database be if you couldn’t read the information stored in it? One of the main pillars of any database system is the programming language that you use to extract data from the database. This is where SQL comes along. But, what is SQL?
Well, SQL stands for …
Imagine how cool would it be: you are on vacation on a beach when you receive a panicked email from your client telling you he has lost all his data. You take your smartphone, log in to sqlbak.com, press “Restore” next to the last backup, and in a few minutes tell the client that his database was restored. This is as close to James Bond as a database administrator could ever get!
SQL Server has such a thing as transaction log tail backup. In this article, we will figure out what it is, why it is needed, and how to do it.
In this article, we will offer information about tail-log backups, a feature that is available for SQL Server versions 2005 and newer. This is a topic which you should be aware of if your backup and restore process for your SQL Server databases is using either the FULL or Bulk-Logged recovery model.