Fix VBO unindexed repository by editing PostgreSQL with PGAdmin
Fixing an Unindexed Backup Repository in Veeam Backup for Microsoft 365 v8.x (PostgreSQL) Overview When a Veeam Backup for Microsoft 365 (VB365) backup repository becomes stuck in an Unindexed state, new backups and restores can stall. The root cause is usually an interrupted or failed repository indexing session. This guide walks you through safely resetting the indexing_state flag in the VB365 PostgreSQL database and restarting the indexing session so the repository returns to a healthy state. Important — Read First Prerequisites Step 1 — Identify the Repository GUID Open an elevated PowerShell on the VB365 server and run: Import-Module Veeam.Archiver.PowerShell $repository = Get-VBORepository -Name “<Repository Name>” $repository | Select-Object Name, Id, IsIndexed Example output: Name Id IsIndexed—- — ———Unindexed Repo f7bf9987-6221-4f70-b8f6-ca6654e7d567 False Record the Id (GUID) for later. Tip IsIndexed should be False when the repository is unindexed. Step 2 – Install pgAdmin (if needed) Step 3 — Connect to the Veeam PostgreSQL Server Step 4 — Open the VB365 Database in Query Tool Step 5 — Verify Repository State Run, by pasting this into the query tool and clicking on the PLAY button to run the query: SELECT id, name, indexing_state FROM public.repositories ORDER BY id ASC; Step 6 — Reset the Indexing State In the same Query Tool window: UPDATE repositories SET indexing_state = 0 WHERE id = ‘f7bf9987-6221-4f70-b8f6-ca6654e7d567’; Step 7 — Restart the Indexing Session Back in elevated PowerShell: Import-Module Veeam.Archiver.PowerShell $repository = Get-VBORepository -Name “Unindexed Repo” Start-VBORepositoryIndexingSession -Repository $repository Step 8 — Monitor Progress Step 9 — Resume Jobs Once indexing reaches 100 % and the repository state is Ready: Rollback Procedure (If Needed) If the repository fails to index or other errors occur: Troubleshooting Tips Conclusion Resetting the indexing_state flag to 0 and re‑triggering an indexing session is an effective way to recover a repository stuck in an Unindexed state. Always follow best practices—back up first, perform changes during maintenance windows, and validate success before placing the repository back into production rotation. Document version: 2025‑04‑11