April 23, 2008 at 1:02 pm
I have tried to reattach a database on SQL2000. Error code:
5172: The header for file 'databaselog.ldf' is not a valid database file header. The PageAudit property is incorrect.
Device activation error. The physicalfile name 'dataaselog.ldf' may be incorrect. New Log file was created.
I still cannot attach this database. I am presuming it cannot be done.
Maggie
April 23, 2008 at 1:06 pm
Is it a SQL 2000 or a SQL 2005 database?
Databases cannot be downgraded in version. If the DB in question was detached from SQL 2005, it has to be attached to SQL 2005 or higher.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 23, 2008 at 1:45 pm
This is SQL 2000. We do not have 2005.
April 24, 2008 at 5:45 am
Ah - well you did post this in the 2005-specific corruption forum - there's a 7.0/2000 corruption forum too.
If you have backups, now is the time to use them as you've lost your transaction log. Was the database shutdown cleanly or did it become corrupt and you detached it (worst thing you could do)?
If you don't have any backups, the only way to attach this database is to hack it back into SQL Server. See my first response in this thread http://www.sqlservercentral.com/Forums/Topic468713-266-1.aspx
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply