Pb after restoring MSDB in command line
Here's my SQL configuration :
Source SQL Server : MS SQL Server 2000 version : 8.00.2082 (SP4)
Target SQL Server : MS SQL Server 2000 version : 8.00.2082 (SP4)
Instance name for both servers : SQLSERVER2000
SQLBackup version : 126.96.36.199
My goal : how to restore MSDB to another SQL Server?
The steps :
1-Backup MSDB on the Source SQL Server via GUI SQLBACKUP : succeeded
2-MSDB put in mono-user mode : succeeded
3-Stop SQL Server 2000 Agent : succeeded.
3-On Target Server, in command restore MSDB : succeeded (command : SQLBACKUPC -SQL "RESTORE DATABASE MSDB FROM DISK='C:\DATA\MSDB-SOURCE.SQB'" -I SQLSERVER2000)
4- On Target Server : Launch SQL Entreprise Manager : succeeded (I can see jobs coming from Source Server)
My problem : I cannot now connect to my Target Server with GUI SQLBACKUP. I have a red cross on the server symbol at the left on my Targer Server name.
When I check the properties of my server via the SQLBackup GUI, I have these errors in a window (french translation) :
redgate sqlbackup unable to find distributor or the distribution database of the local server, distributor is not installed ...
Thanks for you help.