Forum Discussion

joshlabtech's avatar
joshlabtech
Copper Contributor
Aug 07, 2023

Removing old DB from server, but how do I know server is connected to which DB?

Hi Community,

 

I'm taking over the SQL server from the old timers, now I see that I have alot of servers, but I see that the servers name is different from the SQL DB. Question:

 

May I know what are some of the ways which i can determine which server is to which DB?

 

 

 

Thank you!

 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Aug 07, 2023

     

    May I know what are some of the ways which i can determine which server is to which DB?

    joshlabtech , what for "server" do you mean? One SQL Server can host 1-1,024 databases and that are databases, not server.

    Switch the databases to single user or restricted access, then you will see which application/users complains.

Resources