November 7, 2008 at 7:11 am
This falls under the category of a newbie question. I am not a dba but a consultant who implements accounting software that is run on SQL. I'm trying to gather some information about the best way to manage backups and physical backup files.
For instance, we are setting up backup procedures at our clients - small clients who don't have IT departments let alone dba's - and using maintenance plans that include removing backup history after "x" days. The backups are saved locally on the server.
Typically what do clients do in terms of managing the hard disk space and physically moving backups to tape or offsite to keep the number of backups on the server to a minimum?
The history cleanup maintenance plans don't physically delete the backup files related to the backup history so I am unsure what is the best recommendation for our clients that is simple for them to manage, knowing they are not IT savvy. Is it best just to use windows scheduling to move backup files off the server to something else (ext hard drive or other storage) or are there other ways that are recommended?
November 7, 2008 at 8:00 am
Small companies often don't required/consider DRP or off-site backup
My recommendation is
1. Backup locally (keep a week's rotation for example)
2. Either scheduled task with RoboCopy (or DOS commands), or even do a COPY-ONLY backup simultaneously to several disks
across LAN to different servers (or File Servers, which should have Tape backup)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply