Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Select the instance where your target database is.
  • Select the database you want to update or create a new one one.
  • Specify the location of the data and log files of the restored database. SQL Safe displays each database file (by logical name) and the directory where each will be restored.
  • Choose the appropriate recovery state for the database (Fully Accessible, Accessible but read-only, or Not Accessible).
  • Schedule when the Agent should execute the restore job.
  • Select other restore options options.

How do you change the location of your database files?

...

  • Fully Accessible - Leaves the database operational. No additional transaction logs can be restored.
  • Accessible but read-only (standby mode) - Leaves the database non-operational but able to restore additional transaction logs.
  • Not accessible (no recovery mode) -   Leaves Leaves the database in read-only state and able to restore additional transaction logs.

...