Dropping database on another SQL Server instance

Kishore Karuppanasamy 1 Reputation point
2021-03-29T01:47:27.76+00:00

In the process of automating DB restores on AlwaysOn enabled environment, we are in need to drop the DBs (which are sometimes struck in restoring state) in the secondary servers. I am using the linked server configured between the nodes to drop the DBs on secondary server before adding the restored Dbs back in to AlwaysOn AG.

Is there an other way I can drop DBs on another SQL server instance without using linked server?

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,759 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,555 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101.4K Reputation points MVP
    2021-03-29T22:07:05.727+00:00

    Yes, by running a Powershell script or similar from outside SQL Server. For admin things that span servers, Powershell is often a better option.