To recover a SQL Server database from a failure, a database administrator has to restore a set of SQL Server backups in a logically correct and meaningful restore sequence. SQL Server restore and recovery supports restoring data from backups of a whole database, a data file, or a data pages.
Restore Backup taken using the Backup command. Without backup we will not able to restore data.
The restore may be happen with following scenario.
Restore Backup taken using the Backup command. Without backup we will not able to restore data.
The restore may be happen with following scenario.
- complete restore: Restore an entire database from a full database backup.
- partial restore: Restore part of a database.
- file restore: Restore specific files or filegroups to a database.
- page restore: Restore specific pages to a database.
- transaction log restore: Restore a transaction log onto a database.
- Revert a database to the point in time captured by a database snapshot.
- Online Restore : Online restore is allowed only in Enterprise edition of SQL Server. For more information about online restore visit. Online Restoer
No comments:
Post a Comment