How to put DB in signle user mode which is in Cluster

Vijay Kumar 2,016 Reputation points
2023-02-06T18:46:00.01+00:00

Hi Team,

As part of some activity, i am planning to put SQL DB in single user mode?

This is SQL Cluster (Active/Passive).

What is the procedure?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,801 questions
Accepted answer
  1. CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor
    2023-02-07T02:31:24.4633333+00:00

    Hi @Vijay Kumar

    Please refer to this blog: Starting a SQL Server Clustered Instance in Single User Mode.

    Best regards,

    Cosmog Hong

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,001 Reputation points
    2023-02-07T06:01:38.5833333+00:00

    to put SQL DB in single user mode?

    There is no difference between a clustered and a standalone SQL Server, it's always the same.

    See Set a database to single-user mode