Home Forums SQL Server 2008 SQL Server 2008 Administration Restore a development DB form Prod. RE: Restore a development DB form Prod.

  • June 25, 2013 at 12:08 am

    #1626986

    You've made a type in the restore command. You have missed the ":" after the drive.

    MOVE 'MyDBDW_log' TO 'E\MSSQL\Log\MyDBDW.ldf'

    must be:

    MOVE 'MyDBDW_log' TO 'E:\MSSQL\Log\MyDBDW.ldf'

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **