You may encounter the following error when attempting to connect to a SQL Server in the Registered SQL Servers pane:
This problem may arise after uninstalling the SQL Backup Pro server components. The uninstall process can leave the server components in a partially uninstalled state.
To use SQL Backup Pro on the SQL Server instance:
If you no longer want to use SQL Backup Pro on the SQL Server instance, you can delete the instance from the Registered SQL Servers pane, delete the SQL Backup Agent service for the instance and drop the SQL Backup extended stored procedures from the instance.
To delete the SQL Backup Agent service, use the sc delete <service name>
command. For example, at the command prompt type:
sc delete SQLBackupAgent_PRODUCTION |
You can find out the service name from the Windows Services panel (services.msc).
For more information about the sc delete command, see Microsoft Technet documentation.
To delete the SQL Backup Pro extended stored procedures from the instance, use SQL Server Management Studio's Object Explorer (Databases > System Databases > master > Programmability > Extended Stored Procedures) or sp_dropextendedproc
. For example:
USE master GO sp_dropextendedproc 'dbo.sqlbackup' |
The following extended stored procedures are installed when you install the SQL Backup Pro server components:
sqbmemory
sqbsetlogin
sqbstatus
sqbtest
sqbtestcancel
sqbteststatus
sqbutility
sqlbackup