How to Restore Master database - SQL Server DBA Tutorial

In this video you will learn how to restore master database from backup using SQLCMD as well as using SQL Server management studio. It also demonstrates how to start SQL Server in single user mode and work around to the error " Can't login as SQL Server is in single user mode" even after turning off SQL Server Services.

Script used in video to Restore Master Database in SQL Server

Restore DATABASE master From DISK='C:\SQLSystembackup\master.bak' WITH REPLACE

 
How to Restore Master database - SQL Server DBA Tutorial

No comments:

Post a Comment