Go to the SQL Services and remove the –m parameter. Apply the change and start only the sql service.īefore using the SQL Server you need to revert the single-user mode. Go to start-up parameters and add –m parameter. Right click on sql server service and click properties. This step can be done adding –m parameter on sql services. The first step is to start the instance of the SQL Server in Single-user Mode. Start the SQL Server in Single-user Mode.This is the best solutions in situations that you have a good backup of the database. We will show below the fast way to do the restoring.

The good part is that the restoring of master database is very easy step. Use sql server error log file if anything goes wrong. This is the reason that you need to take seriously the backup of master database.

If the master database is not available you cannot open any other user database and your SQL Cannot start. Including server logins, file locations of databases, configuration details, etc. All the metadata and system-level information regarding SQL Server system stored on this database.

Restore master database in sql server