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

1 comment:

  1. nks for sharing the article, and more importantly, your personal experience mindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story since I can certainly relate and I think others can to
    vidmate.onl

    ReplyDelete