Page History
...
- Use SQL Server Enterprise Manager or Management Studio to close any open connections to the Repository database.
- Use SQL Server Enterprise Manager or Management Studio to take the Repository database offline. If you cannot take the Repository database offline, stop the Collection Service.
- Use a tool such as IDERA SQLsafe SQL Safe to restore the Repository database using the appropriate backup archive file.
- On the computer hosting the SQL Diagnostic Manager services, restart the SQLdm SQLDM Collection and Management services.
- On all existing SQL Diagnostic Manager consoles, reconnect to the SQL Diagnostic Manager Repository by selecting File >Connect to SQLdm SQLDM Repository.
Recovering the SQL Diagnostic Manager services
...
- Log on with an administrator account to the computer on which you want to install the SQL Diagnostic Manager services.
- Run
Setup.exein the root of the installation kit. - Click SQL diagnostic manager on the Quick Start window.
- On the Welcome window of the setup program, click Next.
- Review and accept the license agreement by clicking I accept the terms in the license agreement, and then click Next.
- Accept the default folder for your SQL Diagnostic Manager installation, or click Change to specify a different folder, and then click Next.
- Select the Custom Install setup type, and then click Next.
- Select SQLdm SQLDM Services (also select the Desktop Client if you want to run it on the same computer), and then click Next.
- Specify which SQL Server instance is hosting the Repository database, verify that the displayed database name is correct, and then click Next.
- Specify the account credentials that you want the SQL Diagnostic Manager services to use to connect to the SQL Diagnostic Manager Repository and the monitored SQL Server instances, and then click Next. This account must belong to the sysadmin role on the SQL Diagnostic Manager Repository database and each instance you plan to monitor.
- Click Install to begin your installation.
- Click Finish to exit the setup program.
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...