• I get this message when trying to attach the mdf supplied in the download.

    GO

    CREATE DATABASE pubsdev

    ON PRIMARY (FILENAME = 'c:\dba\redgate\pubsdev.mdf')

    FOR ATTACH

    GO

    same results for

    EXEC sp_attach_single_file_db

    @dbname = 'pubsdev',   

    @physname = c:\DBA\REDGATE\pubsdev.mdf'

     

     

    Server: Msg 1813, Level 16, State 2, Line 1

    Could not open new database 'pubsdev'. CREATE DATABASE is aborted.

    Device activation error. The physical file name 'd:\ssc\MSSQL$PUBLISHER\data\PubsDev_log.ldf' may be incorrect.