Home Forums SQL Server 2005 Backups Production Server DB backup Restored on Development Server Backup RE: Production Server DB backup Restored on Development Server Backup

  • Restore the full backup WITH Standby. That way the database is readable (but readonly) and you can restore additional logs.

    This sounds like a reporting requirement, not a development environment. In many cases production data MUST NOT be available in development due to confidentiality and privacy concerns.

    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