January 10, 2008 at 1:08 pm
I was trying to refresh a database, I've had all kinds of issues doing it and it's just this one stupid db. The db is on SS7. I've tried to recreate the db and DTS the db from SS2000 to SS7, I've tried to refresh the SS7 db from a SS2000 db - nothing is working
I've dropped the db from SS7, copied the same db from SS2000. I've tried to attach the SS2000 db to SS7 and this is the error I'm getting:
The header for file 'E:\MSSQL7\logs\dist_log.ldf' is not a valid database file header. The PageAudit property is incorrect.
OMG what have I done:crying:
January 10, 2008 at 2:44 pm
You cant restore or attach a SQL Server 2000 database to a SQL Server 7 database and you can only DTS from 7.0 to 2000. I think you are goin to have to script out the database and then populate the data from SQL 2000.
Here is a link to migrate data from SQL 2000 to SQL 7.0
http://www.sqlmag.com/Article/ArticleID/25298/sql_server_25298.html
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply