SQL Server Shutdown for Cluster server

Rohit Kulkarni 676 Reputation points
2022-02-02T11:45:43.757+00:00

Hello Team,

Due to Maintenance activity i need to bring the SQL Server DB down.All 2 server are in cluster.

Whether I need to make all the DB down from the clusters server or if i make DB down from the one of the server is it fine. please advise.

Regards
Rk

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,610 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,081 Reputation points Microsoft Vendor
    2022-02-03T06:50:25.69+00:00

    Hi @Rohit Kulkarni ,

    Could you please descript your question more clearly? Take database offline or take SQL server instance down? This is a SQL server failover cluster instance environment or SQL server AG environment?

    If you want to take SQL server instance down of SQL FCI, you need to shut down all SQL server instance in SQL FCI.

    If you want to take SQL DB offline of SQL AG, you need to remove this DB from SQL AG then take that database offline on all AG replicas, or you will get the error message like below.

    170818-screenshot-2022-02-03-145157.jpg

    >The operation cannot be performed on database "AGDB1" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.
    >ALTER DATABASE statement failed.


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