Most recent edit on 2005-10-14 12:41:55 by EgoWarrior []
Additions:
2. To use more than one tran log us WITH NORECOVERY on all but last restore log
CategoryHowTo
Deletions:
2. To use more than one tran log us WITH NORECOVERY on all but last restore log
Edited on 2005-06-29 10:01:47 by EgoWarrior []
Additions:
4. Run "RESTORE LOG <dbname> FROM <b/up dev name> WITH RECOVERY, STOPAT='<Month Day, Year Time>'"
Deletions:
4. Run "RESTORE LOG <dbname> FROM <b/up dev name> WITH RECOVER, STOPAT='<Month Day, Year Time>'"
Oldest known version of this page was edited on 2005-06-16 17:30:36 by EgoWarrior []
Page view:
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 RECOVER, 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