I ran into an issue where some databases that were deleted out of SQL were still showing up in SharePoint. You can find them in http://[Central Admin URL]/_admin/DatabaseStatus.aspx.
These were causing errors in the SQL logs because SharePoint was trying to open databases that didn't exist
To delete these orphaned databases, I ran two commands.
List the orphaned databases:
Get-SPDatabase | Where{$_.Exists -eq $false}
Delete the orphaned databases:
Get-SPDatabase | Where{$_.Exists -eq $false} | ForEach{$_.Delete()}
When I was done, I ran the list orphaned databases powershell command again to ensure that the databases were deleted.
When I refreshed the Database Upgrade status window in Central Admin, the databases were gone.
- Blogger Comment
Subscribe to:
Post Comments
(
Atom
)
Category
- Active Directory ( 4 )
- App Packaging ( 6 )
- BitLocker ( 9 )
- CrashPlan ( 7 )
- DNS ( 1 )
- DocLink ( 2 )
- Excel ( 2 )
- Exchange ( 4 )
- Group Policy ( 2 )
- Javascript ( 1 )
- OneNote ( 1 )
- Power BI ( 4 )
- PowerShell ( 29 )
- SCCM ( 20 )
- SCCM Device Collections ( 10 )
- SCCM Reports ( 12 )
- SCCM User Collection ( 2 )
- SCSM ( 2 )
- SharePoint ( 42 )
- SharePoint Design ( 19 )
- Skype for Business ( 1 )
- SQL Server ( 3 )
- SSL Certificates ( 3 )
- Teams ( 1 )
- Windows 10 ( 3 )
- Windows 7 ( 4 )
- Windows Server ( 5 )

0 comments:
Post a Comment