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

Copper Contributor

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?

joshlabtech_0-1691383155037.png

 

joshlabtech_1-1691383279894.png

 

 

Thank you!

 

1 Reply

 


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.