469,269 Members | 1,004 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,269 developers. It's quick & easy.

Possibilities to restore an old database

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?

--
Alvin
Feb 16 '07 #1
1 2584
Alvin (in**@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Feb 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Tim Morrison | last post: by
4 posts views Thread by Hardy | last post: by
9 posts views Thread by GL | last post: by
11 posts views Thread by Chris | last post: by
5 posts views Thread by chow.justy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.