Differential Backup

We have an sql database which is about 50GB. Everyday I do 2 different
backups from 2 different programs. The first backup is a full backup
scheduled in sql and runs at 8pm. The second backup is online backup and run
s
at 7 pm from Monday to Thursday as defferential and every Friday as full. My
question is: Because of the daily full backup, is my differential backup
correct or shall I stop the local daily full?Fedias
Your DB is pretty big, so I'd start with FULL backup once a day and
DIFFERENTIAL backup starting from 6AM till 22PM every two/three hours.
Remmeber that DIFF backup contains all data since last FULL backup , thus
every DIFF backup will get bigger than previous one.
Another strategy you might want to create a LOG backup without doing DIFF
one. It gives possibility to recover your dtabase at point of time in cas
of crashing/
http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting best practices

"Fedias Papadopoulos" <Fedias Papadopoulos@.discussions.microsoft.com> wrote
in message news:D2A26087-0483-4473-B4DB-3E79BAE05FE4@.microsoft.com...
> We have an sql database which is about 50GB. Everyday I do 2 different
> backups from 2 different programs. The first backup is a full backup
> scheduled in sql and runs at 8pm. The second backup is online backup and
> runs
> at 7 pm from Monday to Thursday as defferential and every Friday as full.
> My
> question is: Because of the daily full backup, is my differential backup
> correct or shall I stop the local daily full?|||Thanks Uri,
Is very difficult to make daily full backup using my online backup solution
(www.cybackup.com) because the compressed full backup is about 6.5gb and
takes about 30 hours to go offsite. This solution makes only full and
differential backups. So we do daily dif backups and every friday a full. So
my wonder is, does the daily second full backup we do from sql affects the
dif backup of the online backup
"Uri Dimant" wrote:

> Fedias
> Your DB is pretty big, so I'd start with FULL backup once a day and
> DIFFERENTIAL backup starting from 6AM till 22PM every two/three hours.
> Remmeber that DIFF backup contains all data since last FULL backup , thus
> every DIFF backup will get bigger than previous one.
> Another strategy you might want to create a LOG backup without doing DIFF
> one. It gives possibility to recover your dtabase at point of time in cas
> of crashing/
> [url]http://vyaskn.tripod.com/ sql_server_administration_best_practices
.htm#Step1[/url
]
> --administaiting best practices
>
>
>
>
>
>
>
>
> "Fedias Papadopoulos" <Fedias Papadopoulos@.discussions.microsoft.com> wrot
e
> in message news:D2A26087-0483-4473-B4DB-3E79BAE05FE4@.microsoft.com...
>
>|||Fedias
Yes it does
"Fedias Papadopoulos" <FediasPapadopoulos@.discussions.microsoft.com> wrote
in message news:46AC2224-4B54-413C-A9B9-00C85968C793@.microsoft.com...[vbcol=seagreen]
> Thanks Uri,
> Is very difficult to make daily full backup using my online backup
> solution
> (www.cybackup.com) because the compressed full backup is about 6.5gb and
> takes about 30 hours to go offsite. This solution makes only full and
> differential backups. So we do daily dif backups and every friday a full.
> So
> my wonder is, does the daily second full backup we do from sql affects the
> dif backup of the online backup
> "Uri Dimant" wrote:
>|||In order to restore a diff backup, you need to first restore *the most recen
t* full backup. In 2005,
you have a new option, though. Check out the COPY_ONLY option.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Fedias Papadopoulos" <Fedias Papadopoulos@.discussions.microsoft.com> wrote
in message
news:D2A26087-0483-4473-B4DB-3E79BAE05FE4@.microsoft.com...
> We have an sql database which is about 50GB. Everyday I do 2 different
> backups from 2 different programs. The first backup is a full backup
> scheduled in sql and runs at 8pm. The second backup is online backup and r
uns
> at 7 pm from Monday to Thursday as defferential and every Friday as full.
My
> question is: Because of the daily full backup, is my differential backup
> correct or shall I stop the local daily full?|||> If someone performs an ad-hoc backup for whatever reason during the week, say prior to a r
oll-out,
> I assume the DIFFERENTIAL backup that night will only include changes back to the
ad-hoc backup?
Yes, assuming that the ad-hoc backup was a full database backup.

> Can I force it to go back to the Saturday one at all?
No. However the ad-hoc backup should have been taken using the COPY_ONLY cla
use (new in 2005). That
will not break the backup sequence for diff backups.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ben Rum" <bmwbase-newsgroup@.yahoo.com> wrote in message news:eul5oi$h51$1@.news-02.connect.c
om.au...
> Just want to clarify the date from which a DB backup with DIFFERENTIAL opt
ion includes its
> changes.
> I have a db which I do a full backup on Saturday, and a differential the o
ther days (this is
> plenty in our case)
> If someone performs an ad-hoc backup for whatever reason during the week,
say prior to a roll-out,
> I assume the DIFFERENTIAL backup that night will only include changes back
to the ad-hoc backup?
> Can I force it to go back to the Saturday one at all?