I installed SQL Server 2012 trial copy and I am attempting to load the AdventureWorks DB downloaded from
http://www.wrox.com/WileyCDA/Section/id-811019.html
The zip file only has a MDF file and no LDF.
The following error message is received when attempting to create the DB:
File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWor ks2012_Log.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks2012'. CREATE DATABASE is aborted.
Here is the create DB statement:
create database AdventureWorks2012 on (Filename = 'C:\AdventureWorks2012.mdf') for attach_rebuild_log;
Looking for help to resolve this issue.
Thanks...