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.