We had some problems this morning and need to rollback our database for about one hour. Is this possible and how is it done?
It is a Microsoft SQL 2005 database.
BR Larre
A:
Perhaps the article "Applying Transaction Log Backups" from MSDN might be of any assistance.
Zaagmans
2009-02-25 10:34:23
A:
Have done some investigating and it seems that since our database has RECOVERYMODEL set to SIMPLE it is not possible to do a rollback.
If the database was set up with full recovery model or bulk-logged recovery model it would have been easier.
Zooking
2009-02-25 10:40:24
Hmmm too bad! :-/
Zaagmans
2009-02-25 10:54:19
I suppose the "good news", if any, is that you'll know what to do if it happens again...
Mike Woodhouse
2009-02-25 12:04:42
+3
A:
- Find the previous full backup of your database (BF1).
- Take a backup of the log file (BL1).
- Take a full backup of the database (BF2). Good to have, in case the following steps go wrong.
- Restore the previous full backup (BF1), with NORECOVERY
- Restore the log file backup (BL1) with RECOVERY, and specifying the point in time you want to recover.
Nuno G
2009-02-25 10:40:57