sp_attach error

[Databaseguy]

I'm moving and old database (non production) to a new server using this syntax:

sp_attach_db @dbname = 'THICSOLD', @filename1 ='E:\mssql7\data\ThicsSQL_Data.MDF',@filename2 = 'e:\mssql7\data\ThicsSQL_Log.LDF'

I get this error :

Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'E:\mssql7\data\ThicsSQL_Data.MDF' is not a valid The PageAudit property is incorrect.
database file header Tyrone Lumley
augerinn@gte.net

 

[fluteplr]

Are you sure the mdf file is from the same version of sql server? Including the service packs applied?

If I remember correctly some of the sql 7 service packs changed the data file format.

 

[Databaseguy]

Yeah, my mistake, sorry.

Different versions.

Thanks though.
Tyrone Lumley
augerinn@gte.net