As a database admin some times we may need to restore the database using previous backup's.There are many restore scenario's are available like full backup restore, full+differential backup restore, and full+ differential backup+ transaction log backup restore, and so on. Here is one more type of restoration is point in time restore.
What is point in time restore? -- we can restore a database up to the point using Point in time recovery. say an example a user database got corrupted @3:59 pm we can restore database up to 3:58 pm using point in time recovery.
What we need ? -- Database should be configured in full or bulk logged recovery model. both full backup and log backup's should be valid.
Here is the scenario i am giving you as an example.
Hope this will help you..
What is point in time restore? -- we can restore a database up to the point using Point in time recovery. say an example a user database got corrupted @3:59 pm we can restore database up to 3:58 pm using point in time recovery.
What we need ? -- Database should be configured in full or bulk logged recovery model. both full backup and log backup's should be valid.
Here is the scenario i am giving you as an example.
Hope this will help you..
Post a Comment