SQL Server Performance

Standby Server DB Failed To Restore

Discussion in 'SQL Server 2005 Replication' started by travistan, Feb 8, 2009.

  1. travistan New Member

    Hi , I created a standby DB to restore the transaction logs. It running fine quite some times , but recently having an issue , the replicated DB keep showing the "restoring" status. How can I "reactivate" the replicated the DB to continue the rest of the restore transaction logs process ?Thanks ,Travis
  2. satya Moderator

    What was the statement used to RESTORE this backup?
    Try to restore it again using NO RECOVERY that will allow to restore corresponding tlog backups.

Share This Page