In the event that your existing SQLdm Repository is no longer available, you can recover your SQLdm installation back to the last point a backup occurred.
Recovering the SQLdm Repository
To recover lost or damaged data, restore the SQLdm Repository database using the following guidelines:
- Perform a full restore
- Schedule the restore during off-hours, or times when you expect the least collection activity
To restore the Repository database:
- 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 to restore the Repository database using the appropriate backup archive file.
- On the computer hosting the SQLdm services, restart the SQLdm Collection and Management services.
- On all existing SQLdm consoles, reconnect to the SQLdm Repository by selecting File > Connect to SQLdm Repository.
Recovering the SQLdm Services
To install the SQLdm services:
- Log on with an administrator account to the computer on which you want to install the SQLdm services.
- Run Setup.exe in 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 SQLdm 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 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 SQLdm services to use to connect to the SQLdm Repository and the monitored SQL Server instances, and then click Next. This account must belong to the sysadmin role on the SQLdm Repository database and each instance you plan to monitor.
- Click Install to begin your installation.
- Click Finish to exit the setup program.