Город МОСКОВСКИЙ
00:13:31

How to Start SQL server in Single user mode || Ms SQL

Аватар
Как Сделать Уникально
Просмотры:
30
Дата загрузки:
10.09.2023 14:34
Длительность:
00:13:31
Категория:
Обучение

Описание

Starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role.

Only one user can connect to the server.

Why to start in Single user mode??
1. To restore a master database or other system databases from the backup.
2. To change server configuration options.

Watch full video to know more.
#StartSQLinSingleUserMode

Рекомендуемые видео