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
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