How to recover Missing Data in SQL Server Using a Partial Restore

오늘 무엇을 도와드릴까요?

Issue:

Data is missing from a database or the database is corrupted.

Product Line:

Power Monitoring Expert

Environment:

SQL Server Instance

Cause:

Part of a SQL Server database may be missing or corrupted. A partial restore can be used to recover specific filegroups or extract missing records without restoring the entire database.

Resolution:

Warning: Irreparable database damage can occur. This procedure must only be performed by users experienced with SQL Server Management Studio (SSMS). Always back up all databases before proceeding.

If you suspect part of a database is missing or corrupted, you can perform a partial restore into a separate database. This allows you to analyze or extract the missing data safely.
Partial restores work at the filegroup level. The PRIMARY filegroup is always restored. Filegroups not restored remain offline.

Steps to Perform a Partial Restore:

1. Run a partial restore to a new database name and location

Use the PARTIAL option and MOVE clauses to redirect data files.

Example:

RESTORE DATABASE new_partial_data

FILEGROUP = 'DataFiles'

FROM DISK = 'G:\mydata.dmp'

WITH FILE = 1,

NORECOVERY,

PARTIAL,

MOVE 'mydata' TO 'G:\mydata2.pri',

MOVE 'mydata_log' TO 'G:\mydata2_log.log',

MOVE 'mydata_data_2' TO 'G:\mydata_data_2.dat2';

2. Extract the needed data from the partial restore

After the partial database loads:

Query the tables containing the missing data
Export results as needed
Insert the recovered data back into the original database (via INSERT…SELECT, SSIS, or manual operations)

게시 대상: 슈나이더 일렉트릭 Korea

게시 날짜:2014. 12. 19.최종 수정 날짜:2026. 1. 27.

제품군

Power Monitoring Expert 9.x

제품군