SqlBak Blog

To backup or not to backup: SQL Server’s master, msdb and model

In addition to the user databases that a SQL Server administrator can create, there are also system databases. The primary ones visible in Object Explorer are master, msdb, model and tempdb. All these databases, except for tempdb, support backup operations. In this article, we’ll discuss whether these databases need to be backed up, and if … Read more

Complete guide to restoring SQL databases from BAK files in SQL Server

Restoring SQL Server databases from backup files is an important task for database administrators. In this article, we will discuss what backup files are and how to load a BAK file into SQL Server.

 

What are BAK files in SQL Server?

BAK files are files created by SQL Server, with the file extension .bak, that contain one or more backups of SQL Server databases. They are designed to restore databases to the state they were in at the time the backup was created.

These files are a physical copy of the data from the database files (.mdf и .ldf) and are not intended to be viewed directly in a text editor.

Importing a BAK file in SQL Server involves restoring a database. You can restore databases from these files using T-SQL commands, graphical utilities such as SQL Server Management Studio or SQLBackupAndFTP, as well as from the command line.

There are several graphical user interface tools available.

Read more