SqlSyncStoreRestore.PerformPostRestoreFixup Method

  • Article

Updates synchronization metadata in a SQL Server database after the database has been restored from a backup.

Namespace: Microsoft.Synchronization.Data.SqlServer
Assembly: Microsoft.Synchronization.Data.SqlServer (in microsoft.synchronization.data.sqlserver.dll)

Syntax

'Declaration
Public Sub PerformPostRestoreFixup
'Usage
Dim instance As SqlSyncStoreRestore

instance.PerformPostRestoreFixup

public void PerformPostRestoreFixup ()

public:
void PerformPostRestoreFixup ()

public void PerformPostRestoreFixup ()

public function PerformPostRestoreFixup ()

Remarks

Use this method after you have restored a SQL Server database from a backup. Sync Framework updates synchronization metadata for all scopes that are configured in the database. For more information, see How to: Backup and Restore a Database (SQL Server).

Example

The following code example restores a server database by calling one of the sample Utility methods, and then calls PerformPostRestoreFixup to update metadata. To view this code in the context of a complete application, see How to: Backup and Restore a Database (SQL Server).

Utility.RestoreDatabaseFromBackup();


// Call the API to update synchronization metadata to reflect that the database was
// just restored. The restore stored procedure kills the connection to the
// server, so we must re-establish it.
SqlConnection.ClearPool(serverConn);
serverConn = new SqlConnection(Utility.ConnStr_SqlSync_Server);
SqlSyncStoreRestore databaseRestore = new SqlSyncStoreRestore(serverConn);
databaseRestore.PerformPostRestoreFixup();

Utility.RestoreDatabaseFromBackup()


' Call the API to update synchronization metadata to reflect that the database was 
' just restored. The restore stored procedure kills the connection to the 
' server, so we must re-establish it. 
SqlConnection.ClearPool(serverConn)
serverConn = New SqlConnection(Utility.ConnStr_SqlSync_Server)
Dim databaseRestore As New SqlSyncStoreRestore(serverConn)
databaseRestore.PerformPostRestoreFixup()

See Also

Reference

SqlSyncStoreRestore Class
SqlSyncStoreRestore Members
Microsoft.Synchronization.Data.SqlServer Namespace