May 14, 2007 at 11:14 pm
Hi all,
My Backup process for production database server is as follows
Database size 2GB
Full backup twice a day.
Differential backup every hour with append mode.
Transaction Log Backup every 20mins.
I created this strategy for not to rely on Transaction Log backup, so i created differential backup every hour.
My question is "IS it sounds good with above backup process" &
Differential Backup with append mode is good option.
Please suggest me in this issue
Thanks in advance
Karna
During backup process in SQL Server 2000 using EM Differential backup process, append & Overwrite is out there.
May 15, 2007 at 12:05 am
That's a lot of backups for a 2 GB database
If you have the CPU, time and space to spare, why not?
As for backing up the differentials to a single file, it depends on the reliability of your disks. With a single file, you risk losing all your differential backups should that single file get corrupted.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
May 16, 2007 at 11:51 am
I would definitelt NOT use append mode for backup files. The potential for data loss exists. Granted it is rare that an appended backup file goes bad. But, it will go bad when you leaset expect it - like when you need to perform a restore ! Now some other thoughts ... The plan sounds like a bit much when mixing the tlogs and diffs. Maybe diffs every 4 hours with the tlogs is another option. For a database as small as 2 Gb I would do a full backup daily and tlogs every 15 minutes.
However the real question is "Have you ever tried to recover the database".
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply