Loading...

SQL Restore Operations

You can restore a SQL database from any of the following backups:

  • The most recent backup
  • A backup from a specified date and time

You can also perform a point-in-time restore for a database.

Restore Destinations

You can perform any of the following restore operations:

  • In-place restore

    When you restore a database in place, you restore it to the same path on the same client from which the database was backed up.

    The restore operation will overwrite the source data on the database.

  • Out-of-place restore

    When you restore a database out of place, you can restore it to any one of the following destinations:

    • A different client from which the database was backed up
    • A different instance from which the database was backed up
    • A different database name
  • Restore to Disk

    You can restore SQL Server data directly to a disk from the Admin Console.

    This restored data on the disk can be used later to perform database restore using SQL Management studio or any other third party tools.

Last modified: 12/4/2018 9:56:50 PM