Point in Time Restores

[Dishant]

Can anyone kindly elaborate if possible with example the concept of Point in Time Restores as I have heard this terminology many times.

As this point in time restore is possible in SQL, Domino etc.

Thanks and Regards,

Dishant Dhokia

[AmolB]

Hi Dishant 

 Refer to the below non symantec article.

 http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.bar.doc/barmst138.htm

[Dishant]

I read that article earlier itself but I was not able to understand the concept clearly. Is it possible can you provide an alternative to this.

[Kiran_Bandi]

Hi Dishant,

Windows System restore you may be knowing.

Point Intime Restores also works just like the same as Windows System Restore.

Any harmful changes made to your system can be undone by restoring the system to an earlier time.

With SQL it is very useful.

/* EDIT

This non-sym article may explain you better about the concept.

http://www.databasejournal.com/features/mssql/article.php/3530616/Point-in-Time-Recovery.htm

*/

[pkh · Accepted solution]

Point-in-time restore means restoring your databases to a certain point in time.  For example, you backup your SQL database at 0100 hrs.  At 1600 hrs, your users discover that they have made some mistakes siince 1500.  You can restore the database from your backup.  This means that restored database is at the state it is at at 0100 hrs and this means that your users would have to re-enter all their transactions since that time.

Using your database backup plus the SQL database log, you can restore the database to the state it is at at 1500 hrs and save your users tons of work.  Restoring to 1500 hrs is point-in-time restore.

Point-in-time restore is possible with SQL databases with transaction logging and likewise Domino databases with transaction logging.

[Dishant]

Thanks everyone!!!!

[teiva-boy]

When you purchase BackupExec, you get CPS (Continuous Protection Server) which was created to be able to give you a fantastic RPO of minutes from within your failure.  

CPS was designed for file servers, Exchange and SQL, nothing else that I'm aware of?  But it'll capture transaction logs in near real-time so that you can replay those logs up to the point of failure.  

[Turls]

@Dishanth! can youp please confirm on a comment that provided you the solution? Thanks!