dtocco
asked on
Best Practice Question - Backup of Exchange and SQL Databases
Hello,
I have a quick question. I am near completion of implementing a new backup strategy. I have decided to use the Grandfather-Father-Son tape rotation strategy. My question is how fellow admins/techs handle daily backups of databases such as Exchange and SQL dbs. For example, M-Th I am going to be running an incremental backup. However, I don't feel very confident backing up my Exchange Information Store or other SQL Applications using the incremental method. Maybe I'm paranoid and should not 2nd guess. The other option therefore is using a FULL backup on each db and Exchange. That is fine (and actually what I previously did), however that somewhat defeats the purpose of an incremental backup.
Any thoughts or ideas of best practices, what works for you, etc. I would be much obliged..
Thanks,
DT
I have a quick question. I am near completion of implementing a new backup strategy. I have decided to use the Grandfather-Father-Son tape rotation strategy. My question is how fellow admins/techs handle daily backups of databases such as Exchange and SQL dbs. For example, M-Th I am going to be running an incremental backup. However, I don't feel very confident backing up my Exchange Information Store or other SQL Applications using the incremental method. Maybe I'm paranoid and should not 2nd guess. The other option therefore is using a FULL backup on each db and Exchange. That is fine (and actually what I previously did), however that somewhat defeats the purpose of an incremental backup.
Any thoughts or ideas of best practices, what works for you, etc. I would be much obliged..
Thanks,
DT
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Then there should be no problem, and for me "best practice" is still a dif backup... I think the others here would agree (including it seems, you).
I'd stick to full for Exchange and SQL if you can afford the time, plus exclude the Exchange mailboxes and put deleted retention time to 7 days instead. There isn't really such thing as a differential or incremental backup of a database, it just skips backing up the database completely and does a diff or inc of the transaction logs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The software we are using is Symantec (Veritas) BEWS v10.d. I have the remote agents for SQL and Exchange.