All geek questions in one place

Rollback a full database one hour

We had some problems this morning, and we need to roll back our database for about an hour. Is this possible and how is this done?

This is a Microsoft SQL 2005 database.

+3
source share
3 answers
  • Find the previous full backup of your database (BF1).
  • Back up the log file (BL1).
  • Make a full database backup (BF2). Nice to have if the next steps go wrong.
  • Restore previous full backup (BF1) with NORECOVERY
  • Restore a backup copy of the log file (BL1) using RECOVERY and specify the point in time that you want to restore.
+3
source

- , , , RECOVERYMODEL, SIMPLE, .

, .

0
  1. Select your database.
  2. Then select Tasks / Restore / Database.
  3. In the database recovery dialog box, select the Timeline option
  4. Enter the time you want to restore your database.
  5. Click OK
  6. Good again.
  7. Your database has been updated successfully.
0
source

Source: https://habr.com/ru/post/1703802/

More articles:


All Articles