Secondary Server instance is not in the Restore to list?

• 
  Have you registered the 2nd server instance in the GUI (Servers Panel)?

  petey January 20, 2006 11:27

  - 0 +
• 
  It was already registered when I was running version 3. Actually, I upgraded the version 3 to 4 on the same machine. So, my SQL backup GUI already have two instances of SQL Server.
  
  Do I need to register it again after removing it from the SQL Backup GUI?

  essamughal January 20, 2006 11:48

  - 0 +
• 
  If you already have both instances registered in the SQL Backup GUI, you should be able to select both instances during the restore setup phase in the log shipping wizard.
  
  Were both servers listed on step 1 of the wizard?

  petey January 20, 2006 12:07

  - 0 +
• 
  Yes, both the instances are coming in the list to select the backup from any server. But, the Secondary instance is not coming in the Restore to List, which is not helping me, I had to use my old script from version 3 to setup restore jobs. I was not able to restore on my secondary instance using the GUI but I did it using the script which I created using version 3.
  
  Need response.

  essamughal January 20, 2006 12:15

  - 0 +
• 
  I could not reproduce your error. The list of servers from the step 1 is bascially copied to the list of servers on step 5.
  
  Do you encounter this everytime you start the log shipping wizard?

  petey January 20, 2006 12:28

  - 0 +
• 
  I am using Restore Wizard not Log Shipping Wizard.
  
  I deleted the Registration and re-register the secondary server but it is still not showing the server in the Restore to List.
  
  thanks for quick response.

  essamughal January 20, 2006 13:12

  - 0 +
• 
  Sorry for the confusion.
  
  The list of servers you can restore to is determined by the location of the file. You cannot restore a file located on Server A to Server B, as Server B would not know how to get the file.
  
  So, the only servers that will get listed in step 3 of the wizard will be Server A, and any other SQL Server instances on Server A i.e. all servers that can access the file locally.

  petey January 20, 2006 13:19

  - 0 +
• 
  Point # 1:
  Okay, I am running both the instances on the same machine and trying to simulate automatic backup and restore from one primary instance to secondary instance. So, Server A and Server B are on the same machine and server B can access the backup file since it is on the same local machine.
  
  Point # 2:
  I have implemented same thing in version 3 b/c I've testing the version for last 10 days and I just installed version 4 and I am unable to select Secondary server yet.
  
  Point # 3:
  Let me check the Log Shipping Wizard as well.
  
  thanks

  essamughal January 20, 2006 13:35

  - 0 +
• 
  Did you select the file from a named instance? If so, that's a bug and will be fixed in the next update. Thanks for bringing this to our attention.

  petey January 20, 2006 13:41

  - 0 +
• 
  I think named instance means the instance installed on the same machine, then yes.
  
  Were you able to re-create that case at your side?
  
  I have to check the Log Shipping Wizard as well.

  essamughal January 20, 2006 13:52

  - 0 +

Add comment

Please sign in to leave a comment.