Attach the renamed collection database - Not Working

[gl1tch]

I'm using TFS 2018, as i cannot find any instructions for splitting the collection in this version.

I've followed all the steps exactly for this article. I'm trying to split a Project collection into two which will reside on the same server (TFS) and the restored database is on the same server as the original. I'm getting an error stating that the "No attachable databases were found". I can see my original collection and have brought that one back online, but cannot see the extra one i created and restored on the SQL server.

I can connect to the new one of the SQL server instance with the same account that is running TFS, please help

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 0b3f5fab-8c1a-d18c-09d9-5dd94e0e3d75
• Version Independent ID: 71173705-bc5b-79ef-cf92-8b3370ec276b
• Content: Split a project collection - Azure DevOps Server & Team Foundation Server
• Content Source: https://mseng.visualstudio.com/DefaultCollection/TechnicalContent/_git/tfs-docs-pr?path=%2fdocs%2fserver%2fadmin%2fsplit-team-project-collection.md&version=GBlive&_a=contents
• Product: devops-server
• Git Login: elbatk
• Microsoft Alias: aaronha

[Thaoden]

I faced the same issue when restoring the new database directly from the old database. When restoring from the database backup file, the new and the old database are both displayed for attaching. Maybe this helps.