O envio de formulários no site de suporte está temporariamente indisponível para manutenção programada. Se precisar assistência imediata, entre em contato com o suporte técnico. Lamentamos o inconveniente.
How to move the SQL Server PI repository to a different host or server
Descrição
How can a SQL Server PI repository be migrated from to another (different) MS SQL Server machine?
Resolução
The follow steps can be used to move a SQL Server PI repository between different systems.
Disconnect the PI extension from all of the agents by selecting all of the database agents with PI using the repository from Global View (Databases dashboard), clicking Settings then Administration, and then selecting the agent checkboxes and Disable in the SQL Performance Investigator panel
Delete the SQL PI repository agent (with the letters SPI ) in the agent type from Agent Status (DBSS-SPIRepository, SPIRepository, etc).
Move the PI database to the new instance (i.e. detach/attach, backup restore, etc.)
Add the PI extension back to one database agent to recreate the SPI agents by Navigating to the Global View (Databases) dashboard, clicking Settings then Administration, and then selecting the agent checkbox and Enable in the SQL Performance Investigator panel. Fill in any of the necessary connection details when prompted in the popups.
When prompted in the schema creation popup to confirm the repository database path locations, choose an existing PI database in the pulldown option at the bottom of the popup.
Navigate to PI, wait a couple minutes to make sure the data is collecting and extend the range to one week or more to look at historical data
Add the PI extension the rest of the database agents by navigating to the Global View (Databases) dashboard, selecting the other DB agents, clicking Settings then Administration, and then selecting the agent checkbox and Enable in the SQL Performance Investigator panel.
Criado em: 6/22/2021 Última atualização em: 8/15/2024
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Bem-vindo ao Suporte
Você pode encontrar ajuda de suporte on-line para *produto* da Quest em um local de suporte afiliado. Clique em Continue (Continuar) para ser direcionado ao conteúdo de suporte correto e à assistência a *produto*.
Search All Articles
Encerramento do suporte aos navegadores IE 8, 9 e 10
O Portal da Quest Software não é mais compatível com IE8, 9 e 10. Recomendamos a atualização do navegador para a versão mais recente do Internet Explorer ou do Chrome.
