By using this trace flag, we will be able to start SQL Server and take a backup of the master and msdb databases. Remember that when SQL Server starts it performs a recovery of the databases in order to make them ready to be used. You can use the undocumented trace flag 3608 as a startup parameter that makes SQL Server start without recovering databases. Using Trace Flag 3608 to Start SQL Server In such case, we will need to make a backup of those databases, but the problem is that we can’t start our instance of SQL Server. Let’s assume that you don’t have those backups. What will mark our course of action is whether you have a recent backup of master and msdb databases. Remember that in order to perform a restore we need the SQL Server instance up and running and it can’t start without the model database. Luckily there is a workaround to this problem that I show below. We probably all agree that this is the proper first step in order to recover a database, including the system databases master and msdb, but for the model database things are different.Īt first you may think having a backup of the model database will make things easier, but we will see that it is irrelevant having a model database backup in this scenario. Usually when we have a problem in one of our databases, the first thing that comes to mind is to check if we have a backup. As a consequence, the model database must always exist on a SQL Server instance.

This is also used for the tempdb database which is created every time SQL Server is started.

The model database is used as the template for all new databases created on an instance of SQL Server.

Sql server backup master