itsai6668
asked on
How to fix the msg 5172 after attach acopied .mdf and .ldf
I copied 2 files .mdf and .ldf then I tried this:
EXEC sp_attach_db@dbname = N'portal_Bill'.
@filename1 = N'd:\MSSQL7\Data\portal_Bi ll_Data.MD F',
@filename2 = N'd:\MSSQL7\Data\portal_Bi ll_Log.LDF '
server: msg 5172, level 16, state 15, line 1
The header for file 'd:\MSSQL7\Data\portal_Bil l_Log.LDF'
is not a valid database file header. The PageAudit property is incorrect.
EXEC sp_attach_db@dbname = N'portal_Bill'.
@filename1 = N'd:\MSSQL7\Data\portal_Bi
@filename2 = N'd:\MSSQL7\Data\portal_Bi
server: msg 5172, level 16, state 15, line 1
The header for file 'd:\MSSQL7\Data\portal_Bil
is not a valid database file header. The PageAudit property is incorrect.
ASKER
If the .mdf and .ldf from server 2000 but need to restore to SQL 7.0 ? OK ??
As far as I know this is not possible. You will have to use DTS to convert the data.
Anthony
Anthony
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks/Jerry
ASKER
any article describes how to connect to SQL Server 7.0 by using the Microsoft SQL Server 7.0 driver for JDBC ??
PRB: SQL Server Backup Performed on Computer Configured with DPT RAID Controller Card May Be Invalid
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b268481
Anthony