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

  • The problem with log shipping is the exclusive access during the restore of the log. Since this is a DEV server, developers would get disconnected every time there is a log restore. This may/may not be acceptable.

    Replication may not work so well if developers are changing the schema.

    That said, it does sound more like a reporting server than a development server.

    Steve