Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    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?


    Tuesday, January 12, 2010 3:24 PM
    |

Answers