AdventureWorks Attach problem

  • Hi,

    I'm trying to attach the data file of Adventureworks. I have download the file from http://msftdbprodsamples.codeplex.com/releases/view/55330

    When I try to attach the file (I remove the log file because I don't have one) I receive the following error:

    The header for file 'C:\AdventureWorksDW2012_Data.mdf' is not a valid database file header. The FILE SIZE property is incorrect.

    My SQL Server version is SQL Server 2012 Developer edition with sp1

    Can someone help?

  • Seemed to work fine for me. Have you run the following command to attach?

    CREATE DATABASE AdventureWorks2012 ON (FILENAME = 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf') FOR ATTACH_REBUILD_LOG;

  • Thank you.

    It's solved

  • foxxo (3/25/2013)


    Seemed to work fine for me. Have you run the following command to attach?

    CREATE DATABASE AdventureWorks2012 ON (FILENAME = 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf') FOR ATTACH_REBUILD_LOG;

    Thank you!

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply