Sharepoint 2016 databases

Question

Sharepoint 2016 databases

Sprocket 21

We are running Sharepoint 2016 and I need to backup its databases on our SQL. We run many databases on our SQL server other than just Sharepoint and Sharepoint was installed and previously updated many years ago by someone else that has left. This means our SQL has about a hundred databases including the Sharepoint with a couple that look the same, but maybe old files.
Is there a way to see what SQL databases Sharepoint is currently using?

Elsie Lu_MSFT 9,801 Reputation points

2021-04-22T08:41:10.157+00:00

Hi @Sprocket ,

Is there any update?I am willing to hear from you.
If you think my suggestion is helpful, you could mark it as an answer. It will help others who meet the similar question in this forum. Also others will directly see the answer.

Thanks,
Elsie Lu

Accepted answer

0 additional answers

Your answer

Elsie Lu_MSFT 9,801 Reputation points

2021-04-22T08:41:10.157+00:00

Hi @Sprocket ,

Is there any update?I am willing to hear from you.
If you think my suggestion is helpful, you could mark it as an answer. It will help others who meet the similar question in this forum. Also others will directly see the answer.

Thanks,
Elsie Lu

Answer 1

Hi @Sprocket ,

If you want to view the database being used, you can run the following command:

Get-SPDatabase | Select displayname, NormalizedDataSource, Type

Or go Central admin > Upgrade and migration > Review Database Status on this page, you will get list of database being used in SharePoint along with Sql Server information:

Reference:
Find out which sharepoint server is using the databases

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Sharepoint 2016 databases

0 additional answers

Your answer