You are here: Re: Possibilities to restore an old database « MsSQL Server « IT news, forums, messages
Re: Possibilities to restore an old database

Posted by Erland Sommarskog on 02/16/07 22:37

Alvin (info@alvin.be) writes:
> Can someone put me on the right track?
>
> I have a .bak file from an MSSQL 7.0 database. I want to restore the
> database in SQL 2000 or 2005, but the restore fails with the error: "An
> exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.Express.ConnectionInfo)" and "I/O error (bad page
> ID) detected during read at offset 0x000000001be000 in file 'C:\Program
> Files\Microsoft SQL Server\MSSQL\Data\CLI_JP.mdf'. (.Net SqlClient Data
> Provider)"
>
> So it doesn't look good. I don't really know the meaning of the error
> and all I have is the .bak file. Is there a way to somehow convert the
> file, or read it?

Seems like the backup is corrupt, ot it is a backup of a corrupt database.

The last-ditch attempt I could think of is to try to find an SQL 7
instance and restore it there. In difference to SQL 2000 and SQL 2005,
SQL 7 would not try to upgrade the database format, and you may thus
be able to avoid the bad page, and with some luck you may be able
to extract some data from it.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация