Sign in

Microsoft.com

Microsoft

Remove From My Forums

How would I know if/which one server is restored after last sync in MSF v2.0 SQL Server to SQL Server scenario?

Question
0

Sign in to vote
Is there any way I can check programmatically if one server is restored after last sync before I call databaseRestore.PerformPostRestoreFixup()? I didn't find any field used to store sync time. Thanks.

-Angela
- Moved by Max Wang_1983 Thursday, April 21, 2011 10:55 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
Thursday, October 22, 2009 9:19 PM

Answers

0

Sign in to vote
Hi,

It is a SQL question. You can query msdb.dbo.restorehistory to get the restore information for each database. A query sample can be found online: http://www.mssqltips.com/tip.asp?tip=1724.

Thanks,
Dong
This posting is provided AS IS with no warranties, and confers no rights.
- Marked as answer by Dong CaoMicrosoft employee, Moderator Tuesday, October 27, 2009 5:38 PM
Tuesday, October 27, 2009 5:38 PM

Moderator