In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
[fault type]
Delete the database file, format the partition, change the file size to "0", or cover the database when using backup to restore the database.
[typical characteristics]
The ◎ database file (MDF, NDF, or LDF) is missing suspect status
◎ database data recovery to earlier data
◆ detection process
a. Analyze the missing database files through the file system
b. Make a comprehensive analysis of the hard disk according to the internal structure of MDF (or NDF) files.
◆ recovery proc
a. Connect the faulty hard disk to a secure data recovery platform and make a complete mirror image of the hard disk to prevent secondary breakage.
Bad
b. Analyze the original file system format
c. Find file directory index and file index information
d. If the file index cannot be found, the whole file is fragmented through the internal structure of the MDF (or NDF) file.
Analysis.
e. Generate database files by reassembling fragments
f. After attaching the database, do a complete DBCC test on the database.
◆ acceptance process
a. Attach the repaired database file
b. Do DBCC test to the database after attaching
c. Query the important table and verify the last update date of the data.
Possible causes of ◎ failure:
◆ artificial misoperation
The ◆ file system is damaged and the computer automatically detects the disk.
◎ Database Protection Tip:
When deleting files and formatting partitions in ◆, please back up the original data first.
When ◆ restores the database, try not to overwrite the existing database, or make a backup before restoring.
◆ checks the file system on a regular basis.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.