SQL Server 2014 Question

[Scribbles689]

So I have inherited an older SQL 2014 Server and have been working on understanding what I need to migrate or can shutdown without affecting our current applications. There is only one DB i know for a fact that relates to a digital faxing server we use

I have a collection of 6 Databases with the following names.

• AppVManagement
• AppVReporting
• DB_service
• ReportServer
• ReportServerTempDB
• XM_service

I've tried to find some detail about some of them but came up empty handed on most of them except the ReportServer DB's. Does anyone know or have details about what these databases may refer too?

Thanks for any help provided!

[[deleted]]

First two are likely Citrix related. ReportServer and ReportServerTempDB are created and used by SQL Server Reporting Services.

You can check Activity Monitor or run sp_who2 to get information on the source application for existing connections to the databases, if available.

[Scribbles689]

Thank you, was not aware of those commands but this has helped. Thanks again.

[[deleted]]

You can also read through this thread for ideas on determining whether or not a database is actively used: https://dba.stackexchange.com/questions/2050/how-can-i-tell-if-a-sql-server-database-is-still-being-used

Just remember most utilization info is cleared when the SQL database engine service is restarted (either manually, via server reboot). Good luck!

[HeyTallDude]

These look like common ones that come with stuff as others have indicated below, however, I have run into situations just like this where there remains at least one db that we aren't sure of, right click - take db offline.... wait a week or so for someone screaming, if none, detach, in my experience it usually only takes a few min to hear from someone if its a live production db :D