copy database

  • when i try this query to attach a database,

    EXEC sp_attach_db @dbname = 'EnvNew',

         @filename1 = 'D:\K-Plus\EngineeringDB\Database\EnvNew.mdf',

         @filename2 = 'D:\K-Plus\EngineeringDB\Database\EnvNew.ldf'

     

    ERROR :

    Server: Msg 5172, Level 16, State 15, Line 1

    The header for file 'D:\K-Plus\EngineeringDB\Database\EnvNew.mdf' is not a valid database file header. The PageAudit property is incorrect.

     

     

     

    pls help me....

  • You try this

    exec sp_attach_single_file_db @dbname = 'Envnew', @physname = 'D:\K-Plus\EngineeringDB\Database\EnvNew.mdf'

    Ramaa

  • Respected Mr. Newbie

    Same Error .... Pls help... the verion in server is 8.0 my pc is server 7.0

    may this be the reason?

     

    exec sp_attach_single_file_db @dbname = 'Envnew',

     @physname = 'D:\K-Plus\EngineeringDB\Database\EnvNew.mdf'

     

     

    Server: Msg 5172, Level 16, State 15, Line 1

    The header for file 'D:\K-Plus\EngineeringDB\Database\EnvNew.mdf' is not a valid database file header. The PageAudit property is incorrect.

  • Hai,

    Pls check the DB version what you are attaching and where you are attaching the database. Still you have problems, Just go through the microsoft website for complete details.

    http://support.microsoft.com/?kbid=268481

    Ramaa

  • Hai,

    Solved your problem?

    May be this is your problem. You are trying attach an mdf file from version 7 to 2000.

    Pl find out version and attach the db on the correct box. Ok

    Ramaa

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

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