Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp_attach_db stored procedure

Status
Not open for further replies.

Lozzer

Programmer
Apr 16, 2002
7
GB
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top