HOWTO Restore MS SQL Databases from the Transaction Logs

1. Create a new backup device in ent. manager
2. Run "BACKUP LOG <db> TO <b/updev name> WITH NO_TRUNCATE"
3. Restore database to version before the point you want, you have to select "leave database non-operational with ability to restore additional transaction logs"
4. Run "RESTORE LOG <dbname> FROM <b/up dev name> WITH RECOVERY, STOPAT='<Month Day, Year Time>'"

Notes:
1. WITH RECOVERY brings db online, doesn't let you use any more transaction logs
2. To use more than one tran log us WITH NORECOVERY on all but last restore log

---

CategoryHowTo