I am trying to do a TFS test restore to new server following the TFS 2010 Backup and Restore processes below verbatim (SQL 2008 SP1):
Backup TFS http://msdn.microsoft.com/en-us/library/ms253070.aspx
Restore to Different Server
Restore Single Server Deployment to New Hardware
I can restore the database to the restoring state on a new server; however, when applying the transaction log backup I don't see any marked transactions to restore to. I don't even get a list to choose from.
I can restore the database to the original server successfully and can see list of marked transactions to restore to.
Is there anything that we could keep me from seeing the list of marked transactions on the new server? Does this have anything to do with the fact that the marks are stored in the msdb.dbo.logmarkhistory database?
Thanks in Advance,
View Complete Post