Backup differential

Hello everybody,
I need to get a differential backup in a small file but i am getting a
trouble ...
I got a Full backup with size=800MB
Then i got a differential backup with size=775B
It is an OLAP database then a lot of tables got a "DELETE FROM" command then
data is inserted again, it happens every early morning.
I hope it is correct, but i am not sure, i need some help with that.Leandro
Look at this very useful article
http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting best practices
"Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
news:#4ZEDzU9DHA.2712@.tk2msftngp13.phx.gbl...
> Hello everybody,
> I need to get a differential backup in a small file but i am getting a
> trouble ...
> I got a Full backup with size=800MB
> Then i got a differential backup with size=775B
> It is an OLAP database then a lot of tables got a "DELETE FROM" command
then
> data is inserted again, it happens every early morning.
> I hope it is correct, but i am not sure, i need some help with that.
>|||I have to say that this database is Recovery Model SIMPLE ...
"Leandro Loureiro dos Santos" <leandro@.email.com> escreveu na mensagem
news:%234ZEDzU9DHA.2712@.tk2msftngp13.phx.gbl...
> Hello everybody,
> I need to get a differential backup in a small file but i am getting a
> trouble ...
> I got a Full backup with size=800MB
> Then i got a differential backup with size=775B
> It is an OLAP database then a lot of tables got a "DELETE FROM" command
then
> data is inserted again, it happens every early morning.
> I hope it is correct, but i am not sure, i need some help with that.
>|||Well, if you delete from and insert into many tables, then you are modifying
many extents, so diff backup is nearly as big as full db backup. Can you
change your data population procedure to incrementaly update the OLAP
database? Or at least to delete only a subset of rows, for example younger
than a month, and then insert only new rows?
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
news:#4ZEDzU9DHA.2712@.tk2msftngp13.phx.gbl...
> Hello everybody,
> I need to get a differential backup in a small file but i am getting a
> trouble ...
> I got a Full backup with size=800MB
> Then i got a differential backup with size=775B
> It is an OLAP database then a lot of tables got a "DELETE FROM" command
then
> data is inserted again, it happens every early morning.
> I hope it is correct, but i am not sure, i need some help with that.
>|||If i keep the ETL this way i will have the same problem with Replication?
Thanks ...
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> escreveu
na mensagem news:udmeT3U9DHA.3380@.tk2msftngp13.phx.gbl...
> Well, if you delete from and insert into many tables, then you are
modifying
> many extents, so diff backup is nearly as big as full db backup. Can you
> change your data population procedure to incrementaly update the OLAP
> database? Or at least to delete only a subset of rows, for example younger
> than a month, and then insert only new rows?
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
> news:#4ZEDzU9DHA.2712@.tk2msftngp13.phx.gbl...
> then
>|||> If i keep the ETL this way i will have the same problem with Replication?
> Thanks ...
Sorry, I don't understand - where does replication fit here? Are you
replicating OLAP database? Which type of replication are you using? Anyway,
replication should gain from smaller updates as well.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||Yes, if you replicate (having deleted then re-inserted many rows), the
replication will go very slowly, as it must do the same...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Leandro Loureiro dos Santos" <leandro@.email.com> wrote in message
news:#4ZEDzU9DHA.2712@.tk2msftngp13.phx.gbl...
> Hello everybody,
> I need to get a differential backup in a small file but i am getting a
> trouble ...
> I got a Full backup with size=800MB
> Then i got a differential backup with size=775B
> It is an OLAP database then a lot of tables got a "DELETE FROM" command
then
> data is inserted again, it happens every early morning.
> I hope it is correct, but i am not sure, i need some help with that.
>|||Leandro
With a datawarehouse (OLAP) system where most of the data
is changing on a daily basis, it might be worth looking at
the source of your data. That is where your backup and
recovery should be pursued. Supplying a new input file to
your system looks to be almost as good as restoring a full
backup.
It is not uncommon with datawarehouses that it is as easy
to recover the database from source as a backup. This is
why it is the exception to the rule that all production
databases should be in full recovery mode.
Regards
John