Hi

You have to have your recovery log in "roll-forward" mode to be able to do 
a point-in-time restore of the database(up to the minute).

This mean that the recovery log isn't purged at every write to the 
database. Instead, the log is purged when a database backup occurs. This 
means that you can restore your database "up to the second" it went down.

Doing backups of the database every minute seems, how am I going to put 
it... Not the best solution. This is not a way to be able to restore the 
database using point-in-time.

Best Regards

Daniel Sparrman
-----------------------------------
Daniel Sparrman
Daniel Sparrman
Exist i Stockholm AB
Propellervägen 6B
183 62 HÄGERNÄS
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51




William Rosette <Bill_Rosette AT PAPAJOHNS DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2002-06-17 14:52
Please respond to "ADSM: Dist Stor Manager"

 
        To:     ADSM-L AT VM.MARIST DOT EDU
        cc: 
        Subject:        Re: DB backups


You can get "up to the minute" if you do enough database backups, and I
still don't understand the "up to the minute" idea.  If you are doing
backups every minute that seems logical but do not most people backup once
a night? and if there is a database backup is not this database backup and
"up to the day" same as "up to the minute?"



                    "Jolliff,
                    Dale"                To:     ADSM-L AT VM.MARIST DOT EDU
                    <[email protected]       cc:
                    OM>                  Subject:     Re: DB backups
                    Sent by:
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MAR
                    IST.EDU>


                    06/14/02 12:21
                    PM
                    Please respond
                    to "ADSM: Dist
                    Stor Manager"






I have suggested this a couple of times, but have been told they need the
ability to restore the TSM server "up to the minute" that rollforward
provides.