We had a hard crash of a database which has left at least one (that we know of) table corrupt. We're not able to validate, query, drop, truncate the table without taking down the database. I am able to query the objects: SELECT sc.* FROM dbo.syscolumns sc INNER JOIN sysobjects so ON sc.id = so.id WHERE so.name = 'fileusertypes'. We want to just kill the table but don't know how at this point. Suggestions? TIA SQL Anywhere 12 |
Some corruptions may prevent operations to remove the table. I assume that since you are only looking at "dropping" that you have no viable backup that can be used? That would be the easiest approach and should get you to a recovered database vs a data salvage. In any event, an approach to take in the absence of a backup can be
1
Thank-you so much for your input!
This is a datamart db, and for the most part can be recre"ted via our nightly pipeline. For that reason, we are continually truncating the log file (-m option). However, there are a couple of transactional tables in the datamart and of course they are the ones corrupted. We believe there are 2, based on multiple queries. We can't even "select top n..." from either. Our thought was to drop them and recover data from a 2 day old backup.
(02 Jul '21, 16:29)
rsnyder
Replies hidden
Hm, does DBISQL only (outside of SQL Central) allow to select from "good" tables? In case of a "fragile" database, I would try to use "simpler" tools, even dbisqlc...
(02 Jul '21, 16:46)
Volker Barth
3
Would you be interested in a blog post that describes how to create a "mini-backup" process like the one used by Foxhound? It works well to frequently back up and restore small but important tables while excluding large tables that are not so important.
(03 Jul '21, 13:10)
Breck Carter
Yes! Sounds like a nice solution for our datamarts. Some have their own more transactional tables.
(06 Jul '21, 07:52)
rsnyder
Do you "mini-backup" to text files (like Foxhound) or also to a separate database via proxy tables (so both databases are only weakly connected)?
(06 Jul '21, 09:36)
Volker Barth
|