Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Always test, and be aware of the possible problems Expand / Collapse
Author
Message
Posted Monday, September 21, 2009 4:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 27, 2014 9:13 AM
Points: 17, Visits: 60
Whilst having "full recovery" allows a "point in time" restore, it also means that you *must* do regular transaction log backups. Not just because this gives you the control over which point in time to restore to, but also because this is how the transaction log is checkpointed. Failure to do this can easily lead to the transaction log growing out of control.

Implementing this does imply a greater level of care in monitoring that the backups are working and running as and when expected.

And the most important thing with ay backup... test it before you need it. You should always go through a restore to makes sure that it works as you expected. The last thing you ever want to do is to have a failure or data loss and find out at that time that the backups are bad.
Post #791019
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse