Hi all,
From the Microsoft codeplex, I have downloaded the AdventureWorks2012_Data.mdf file and saved it in my C:\Temp folder. I executed the following .sql code:
CREATE DATABASE AdventureWorks
ON (FILENAME = 'C:\Temp\AdventureWorks2012_Data.mdf')
For ATTACH;
GO
I got the following message:
File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Log.ldf" may be incorrect.
New log file 'C:\Temp\AdventureWorks2012_Data_log.ldf' was created.
Converting database 'AdventureWorks' from version 705 to the current version 706.
Database 'AdventureWorks' running the upgrade step from version 705 to version 706.
I think that I do not have the AdvendtureWorks2012_Log.ldf file in my C:\ drive that caused the problem in my trial to attach the AdventureWoks2012 to the Databases of SQ ...
Go to the complete details ...