![]() It will automatically create the log file in the same folder. ON (FILENAME 'C:\AdventureWorks2012Data.mdf') FOR ATTACHREBUILDLOG. If you use T-SQL, you can do simply: USE MASTER. Where can I download the AdventureWorks2012_Log.ldfįile? Please kindly help, advise and respond. Once you download the AdventureWorks2012Data data file, you can simply attach it using T-SQL or through the GUI. 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 SQLEXPRESS of my SQL Server 2012 Management Studio. New log file 'C:\Temp\AdventureWorks2012_Data_log.ldf' was created.Ĭonverting database 'AdventureWorks' from version 705 to the current version 706.ĭatabase 'AdventureWorks' running the upgrade step from version 705 to version 706. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Log.ldf" may be incorrect. I got the following message: File activation failure. ON (FILENAME = 'C:\Temp\AdventureWorks2012_Data.mdf') From the Microsoft codeplex, I have downloaded the AdventureWorks2012_Data.mdf file and saved it in my C:\Temp folder.
0 Comments
Leave a Reply. |