Example: Piecemeal Restore of Database (Simple Recovery Model)
Applies to:
SQL Server
A piecemeal restore sequence restores and recovers a database in stages at the filegroup level, starting with the primary and all read/write, secondary filegroups.
In this example, database adb
is restored to a new computer after a disaster. The database is using the simple recovery model. Before the disaster, all the filegroups are online. Filegroups A
and C
are read/write, and filegroup B
is read-only. Filegroup B
became read-only before the most recent partial backup, which contains the primary filegroup and the read/write secondary filegroups, A
and C
. After filegroup B
became read-only, a separate file backup of filegroup B
was taken.
Restore Sequences
Partial restore of the primary and filegroups
A
andC
.RESTORE DATABASE adb FILEGROUP='A',FILEGROUP='C' FROM partial_backup WITH PARTIAL, RECOVERY;
At this point, the primary and filegroups
A
andC
are online. All files in filegroupB
are recovery pending, and the filegroup is offline.Online restore of filegroup
B
.RESTORE DATABASE adb FILEGROUP='B' FROM backup WITH RECOVERY;
All filegroups are now online.
Additional Examples
Example: Piecemeal Restore of Only Some Filegroups (Simple Recovery Model)
Example: Online Restore of a Read-Only File (Simple Recovery Model)
Example: Piecemeal Restore of Database (Full Recovery Model)
Example: Piecemeal Restore of Only Some Filegroups (Full Recovery Model)
Example: Online Restore of a Read-Write File (Full Recovery Model)
Example: Online Restore of a Read-Only File (Full Recovery Model)
See Also
Online Restore (SQL Server)
BACKUP (Transact-SQL)
RESTORE (Transact-SQL)
Piecemeal Restores (SQL Server)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho