Case:
I received a repair database task in the first two days, UFData.mdf, database version 2000; some tables (RDRECORDS) could not be opened.The database of databases to restore this database is relatively high. Not only the data is restored, but also requires the use of friends to read the database. This generally requires fixed on the original database and cannot export data.Well, let me load to see what is the specific problem.
Solution:
The file cannot be loaded here. By looking at the error message, it may be that the page pointed to by a certain page of the system table is not on the page of the system table. What should I do? I think of a way to mount the database first. You can only use the method of removing the log and attaching mdf, use mastersp_configure ‘allow updates’,1 reconfigure with override ????update sysdatabases set status=-32768 where dbid=DB_ID(‘UFDATA’)dbcc rebuild_log(‘UFDATA ‘,’D:temporary UFDATA _log.ldf’)dbcc checkdb(‘UFDATA ‘) prompts an error when executing dbcc checkdb(‘UFDATA ‘). I found out the name of the table represented by ID 1298871744 through manual analysis and processing, and then exported the data Time to remove the table, and first remove the view or something. Then export the data successfully. Then in the new library, there are no problems with the previous database, and the table data is not lost. Then I use the software to find and import the table content of ID 1298872744 into the new library, and then rebuild the view and some other things, OK, successful.