Post reply

AdventureWorks Attach problem

  • March 24, 2013 at 6:03 pm

    #275541

    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?

  • March 25, 2013 at 1:30 am

    #1600192

    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;

  • March 25, 2013 at 5:10 am

    #1600233

    Thank you.

    It's solved

  • May 2, 2013 at 4:42 am

    #1611840

    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