March 13, 2009 at 12:25 pm
i keep getting these questions wrong when studying for the 70-431
situation is you do full backups on the weekend, diffs on the weekdays and log backups every hour or whatever. then say wednesday night your db crashes at 5am.
i answer to restore the full, latest diff and the log backups. the book says i should do a log backup after the crash. is this even possible or is it just a typo? i've never had anything like this at work.
March 13, 2009 at 12:41 pm
As a general rule you should try and backup the log so that you can restore as much data as possible, and not just to the last full/differential backup. Obviously this depends on the problem - if the server is dead you won't be able to run anything.
As far as the exam is concerned, it mirrors real life - you want to be able to recover as much data as possible (priority 1) in as short a time as possible (priority 2).
March 13, 2009 at 3:07 pm
SQL Noob (3/13/2009)
i keep getting these questions wrong when studying for the 70-431situation is you do full backups on the weekend, diffs on the weekdays and log backups every hour or whatever. then say wednesday night your db crashes at 5am.
i answer to restore the full, latest diff and the log backups. the book says i should do a log backup after the crash. is this even possible or is it just a typo? i've never had anything like this at work.
That is right; that is referred to as Tail Log backup. As mentioned point of recovery is full recovery to point of failure. Not possible at the same time, so unless they mention in the test the database is not recoverable because hard disk died. You should always take a tail log backup; then start your restore operations.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 16, 2009 at 6:48 pm
SQL Noob (3/13/2009)
i keep getting these questions wrong when studying for the 70-431situation is you do full backups on the weekend, diffs on the weekdays and log backups every hour or whatever. then say wednesday night your db crashes at 5am.
i answer to restore the full, latest diff and the log backups. the book says i should do a log backup after the crash. is this even possible or is it just a typo? i've never had anything like this at work.
That was referring to Tail Log backup to get as much data as possible using the command :
BACKUP LOG 'databasename' WITH NORECOVERY if the database is online just to ensure that the data will not change after the backup is done.
BACKUP LOG 'databasename' WITH CONTINUE_AFTER_ERROR if the database is damaged
BOL has very good information on this.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply