November 27, 2009 at 5:32 am
please provide the details about point in time recovery how it works
Regards,
Shivrudra W
November 27, 2009 at 6:39 am
Please try to Google for it and if you have any doubts, please feel free to contact us here. We will be more than happy to help you. I am sure there are articles regarding this here in SSC it self.
-Roy
November 27, 2009 at 6:49 am
shivrudra_2008 (11/27/2009)
please provide the details about point in time recovery how it works
What details are you looking for?
If you are a fresher in SQL DBA field, look for such information in articles that were written for this purpose. Once you read them have SQL Installed on your machine and practise that. You would know more once you start practising the steps, your knowledge increases on them. If you have doubts at that point, you can ask here.
It is broad topic and answering a forum question is not apt to it, since you need to know what is recovery model, and in which recovery model point in time recovery is possible and so on..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 27, 2009 at 7:18 am
I agree with the replies by two star members, its indeed a vast topic to be discussed over here, however in breif, point in time recovery means in instance of db server crash, as a DBA its your job to recover as much data as possible, point in time means that you should be in position to restore the database at the point of failure, so lets say your database server crashed at 1900 hours, you should be able to recover all the data till 1900 hours however its not possible most of the times. so your job is to minimise the data losses by having robust backup plan in place for mission critical databases like banking system where data loss would mean finiancial losses... for such mission critical databases your database should be having fulll recovery model and bakup strategy should cover full, differential and frequent log backup, log backup frequency will be decided by business experts if they agree that business will be fine if they lose data worth 15 minutes then your log bacuk up frequency should be 15 minutes.
November 27, 2009 at 2:54 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply