Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to fix the msg 5172 after attach acopied .mdf and .ldf

Posted on 2003-02-28
6
Medium Priority
?
1,256 Views
Last Modified: 2008-02-01
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_Bill_Data.MDF',
 @filename2 = N'd:\MSSQL7\Data\portal_Bill_Log.LDF'

 server: msg 5172, level 16, state 15, line 1
 The header for file 'd:\MSSQL7\Data\portal_Bill_Log.LDF'
 is not a valid database file header. The PageAudit property is incorrect.
0
Comment
Question by:itsai6668
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 8043612
This probably does not apply, but ...
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
0
 

Author Comment

by:itsai6668
ID: 8043692
If the .mdf and .ldf from server 2000 but need to restore to SQL 7.0 ? OK ??
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 8044031
As far as I know this is not possible.  You will have to use DTS to convert the data.

Anthony
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Accepted Solution

by:
ARSRINI earned 200 total points
ID: 8050657
Do a Export Data from server 2000 to SQL 7.0.

Also when you copied the file, did you first detach the database from the original server?
0
 

Author Comment

by:itsai6668
ID: 8057976
Thanks/Jerry
0
 

Author Comment

by:itsai6668
ID: 8196635
any article describes how to connect to SQL Server 7.0 by using the Microsoft SQL Server 7.0 driver for JDBC ??
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question