Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ron_S
Starting Member
2 Posts |
 Posted - 2008-05-29 : 12:16:40
|
| I have a problem with a database in SQL Server 2000 8.00.194. I have read similar cases in the forum, but in all the cases the expert paulrandal requests sent it a detail of dbcc page (). By mistake the user try to restore a backup on this database, the user realized the error and press the "stop" button of the SQL Server, the process stopped but the database is not recognized from SQL Server 2000. I have opened the file. mdf and the previous data are inside. I attach the database in "DBO Use Only" state using the tool "REBUILD_LOG" when I execute DBCC CHECKDB ('<db_name>') I have the same symptoms that in the post http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53271 Attemp to fecth logical page (1:8945) in data base belong to object 'sysindexes', not to object 'syscolumns' But I don't understand like it has been solved finally. Does is it possible to recover these data?. It is not obligatory it recovered all the database, only some tables to complete manually on to backup of this database. I try BCP, but I have the same error Thank you very much for your collaboration. |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2008-05-29 : 12:33:18
|
| Do you mean the user was restoring a backup of the database *over* the original database and interrupted the process half way though?In that case, your only sensible option is to restore the backup again and let it complete. The user has already destroyed the original database by restoring over it and the best thing to do is to restore the backup and salvage whatever from that database.ThanksPaul RandalSQL Server MVP, Managing Director, SQLskills.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-29 : 13:17:48
|
quote:
Originally posted by Ron_S
I have a problem with a database in SQL Server 2000 8.00.194.
Why don't you have any service packs installed?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
Ron_S
Starting Member
2 Posts |
Posted - 2008-05-29 : 13:45:58
|
| Good afternoon Paulrandal, Thank you very much for your quick answer. I congratulate you for the excellent technical level of the forum. Yes, the technician press the "stop" button of the restore form and the process stopped correctly. In the database exists sensitive information that we need to recover, I have edit the .mdf file and seemingly the restore doesn't begin, the whole infomación of the original database this inside, it is what makes me think that we can extract that information somehow. You knows some tool that allows us to obtain this information? Thank you very much Paul for helping us with this |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-05-30 : 11:06:42
|
| What do you mean 'I have edit the .mdf file"? How did you do that? Why did you do that?Terry |
|
|
|
|
|
|
|
|
CHECKDB returns Attemp to fecth logical page