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

  • Question

  • 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?

    Tuesday, January 12, 2010 3:24 PM