You should have multiple ways to restore..
1 exports hourly / bi-hourly .. etc..
1 Database dumps nightly / whatever
1 OS dump
1 OS dump with Database etc.
Running DB in Parallel
--
stored on NAS for easy recovery.. 1 day ?
Store on tape for Historical 30 days ?
Stored in a Fireproof Safe and the Day before moved to the Safe in another building ?
Stored in a NAS at Higher HQ's ?
Depends how important is the information...
I have chose most of the above..
export bi-hourly
DB backups nightly
OS nightly
- Stored in a SAFE nightly
-Rotated in the SAFE (Off-site)
On 11/4/06, Mosco, John D. <[EMAIL PROTECTED]> wrote:
**__20060125_______________________This posting was submitted with HTML in it___All,
I am trying to find the best way to make sure that I have a good disaster revovery plan. I already set up SQL Backups full and diff etc. From my class two weeks ago (admin 2) it seems the best way to be able to bring your data back though is to do a data export and then import. Is there anyway to automate this on a schedule or do I need to have my junior admins just do this every day ?
Thanks,
John Mosco
W01/GS-11
IT Coordinator
Customer Support Manager
PNG JFHQ J6
Com: 717-861-8143
DSN: 312-491-8143
Fax: 717-861-8414
'We the people'
--
Patrick Zandi __20060125_______________________This posting was submitted with HTML in it___
