Re: Problem SQL 6.5
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/17/04
- Next message: Keith Kratochvil: "Re: Need help with conversion"
- Previous message: Ysandre: "Log files - Location"
- In reply to: Lomu: "Problem SQL 6.5"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 May 2004 22:10:23 +0530
Hi,
In SQL 6.5 the error 605 it is very hard to solve, Execute DBCC CHECKDB on
the database and identify the table got corrupted.
I had many instances of this error and the only way I solved this error is
by:
1. Create a new table with same structure
2. Load the data in batches (You have to write code) to the new table
3. Some time load might stop when it reads the corrupted record, if it stop
ignore that record and continue with next records
4. Once the new table is loaded with data then;
5. Truncate the existing table after verifying the original.
6. Script out the indexes of that table.
7. rename the original table to tablename_old (sp_rename)
8. rename the new table to original
9. Create the indexes using the script generated in step-6
Thanks
Hari
MCDBA
"Lomu" <agallo@tau.org.ar> wrote in message
news:57DBFF6C-EA80-41BF-97E3-D63CA9451AC9@microsoft.com...
> Hi.
>
> I have problem in a SQL 6.5 Database. The error is de 605 " Attempt to
fetch logical page..."
> The solution is in new versions(7 and 2000) execute DBCC checkdb
REPAIR_ALLOW_DATA_LOSS
> or DBCC checkdb REPAIR_REBUILD, but I haven't that solution in 6.5.
> For more details, this error apear when de database one time when the
device not have sufficient space.
> Thanks in advance
> Lomu
- Next message: Keith Kratochvil: "Re: Need help with conversion"
- Previous message: Ysandre: "Log files - Location"
- In reply to: Lomu: "Problem SQL 6.5"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
