SQL-SQL: Use a backup of the Server to initialize a Client

• Question

• 

  

  0

  Sign in to vote

  Hi,
  
  I'm using a hub-and-spoke topology using the SqlSyncProviders, with a SQL Server database (as the server) and  SQL Express databases as the Client (SQLCE is not sufficient). Since I'm using the hub-and-spoke model, my hub, the server database will always contain the latest sync data. Clients will only sync with the Server.
  
  Is it possible to use a backup of the Server and restore it on a new Client? What needs to happen to allow the restored database on the new Client so that it can start synchronizing itself again with the Server?
  
  Should I run the SqlSyncStoreRestore.PerformPostRestoreFixup() on the new client?
  
  
  

  • Moved by Liam Cavanagh - MSFTMicrosoft employee Thursday, January 21, 2010 7:37 PM (From:SyncFx - Microsoft Sync Framework Database Providers)

  Tuesday, January 12, 2010 3:24 PM