Hi guys, I have a database with one table corrupted. I tried to use DBCC CHECKDB to fix the corruption with data loss but I can't. The database can still be used with no problem. Only one table is not accessible.
Now I need to move that database (sql server 2000) to another server (sql server 2008). I tried to restore the backup file but it gave me the error "Could not continue scan with NOLOCK due to data movement" so I have to restore with CONTINUE_AFTER_ERROR option. So the database is restored but it's offline. I brought it online but it's not accessible. Also tried to move to sql server 2005. Same result.
Could someone here please help? Is there any other way to fix the corruption? I tried several tools but it only recover a few tables. If corruption can't be fixed, how can I just restored the corrupted database which can still be used? It's a SAP Database so it has over 10k tables and even more stored proces and views. Too hard to script out everything and bcp out the data.
Thanks a lot!!!
asked Feb 25, 2011 at 11:53 AM in Default
My solution to this would be to get everything but the problem table into another new database(*) from you current system and then restore the data to the problem table from a backup. It will be a bit of a job but it should be reliable.
(*) - I'd go for something like SQL Compare and SQL Data Compare from [RedGate] as those are what we use but there are other products that will help you. SQL Backup does Object Level Recovery so just the required table could be picked out on its own. They do 14 day free trial of full products so you could get this done expense free. I would expect they'd love to hear from you if their tools help you out.: http://www.red-gate.com
answered Feb 25, 2011 at 12:12 PM