Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

SQL SERVER database file deletion and partition formatting solution

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report