Forum Discussion
joshlabtech
Aug 07, 2023Copper Contributor
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 wha...
olafhelper
Aug 07, 2023Bronze Contributor
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.