I have detached a database on one SQL server in the US using the sp_detach_db stored procedure.
When I try to attach it to a different SQL server in the UK using either of these stored procedures:
CREATEDATABASE,
sp_attach_db,
sp_attach_single_file_db
I get the same error message:
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:\yb_sqldb\pc_doc_convert_Data.MDF' is not a valid database file header. The PageAudit property is incorrect.
I am however able to reattach the database on the original SQL server the database was detached from!
Can anyone help me to get to the bottom of this!?
Thanks in advance,
lozzer.
When I try to attach it to a different SQL server in the UK using either of these stored procedures:
CREATEDATABASE,
sp_attach_db,
sp_attach_single_file_db
I get the same error message:
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:\yb_sqldb\pc_doc_convert_Data.MDF' is not a valid database file header. The PageAudit property is incorrect.
I am however able to reattach the database on the original SQL server the database was detached from!
Can anyone help me to get to the bottom of this!?
Thanks in advance,
lozzer.