Home Forums SQL Server 2005 SQL Server Newbies Restore Transaction Log Error: database not in NORECOVERY/STANDBY mode RE: Restore Transaction Log Error: database not in NORECOVERY/STANDBY mode

  • Am I correct in saying that the WarehouseDB that you're trying to restore logs to was online and usable before you started? You set the DB to read only (ALTER DATABASE ... SET READ_ONLY...)?

    If so, then to set that up as a log shipping secondary, you need to drop the DB, restore a new full backup either with STANDBY or NORECOVERY, then you can restore logs. If a DB was recovered and brought online you cannot then restore log backups to it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass