Restore SQL Server Components without Recovering the Database
Use the Do Not Recover Databases option
if you want to apply transaction logs or differential backups to
the restored database.
-
In the Server Connections area
of the navigation pane, connect to a server or host.
-
In the Backup Extensions area
of the navigation pane, select the SQL Server Databases backup extension.
-
Select a component. Restore points for the component
are displayed in the right side of the explorer.
-
Select a restore point.
-
In the Restore Points area of
the action pane, click Restore. The Restore
Snapshot dialog box appears.
-
In the Components area, select
or clear the check boxes next to the components to choose which
components to restore.
-
Select Do Not Recover Databases.
-
Review the restore point details, and click Restore.
Data is not available for the Topic