Database Diff?

I was just looking at my database backups and i noticed there was about a
100MB difference in the backup files. We run optimization plans but those
are done on the weekend and this happened in the middle of the week.
Some people are a little curious as to why the database backup would shrink
so much. I was thinking of trying to do a DB diff between the two but wasnt
sure how to do this. Looked around a little and saw a few tools but i was
looking for a free solution.
Anyone know why this might have shrunk or a tool that i could use to do a
diff?
Thanks
JustinYou could restore a backup before the change, and a backup after the change,
and then use a trial copy of red-gate SQL Compare (or trial versions of
other tools), I guess. Tools like this pay for themselves in the long run,
unless this is the only time you will ever use it (which you can't possibly
know right now).
Aaron Bertrand
SQL Server MVP
"Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>I was just looking at my database backups and i noticed there was about a
>100MB difference in the backup files. We run optimization plans but those
>are done on the weekend and this happened in the middle of the week.
> Some people are a little curious as to why the database backup would
> shrink so much. I was thinking of trying to do a DB diff between the two
> but wasnt sure how to do this. Looked around a little and saw a few tools
> but i was looking for a free solution.
> Anyone know why this might have shrunk or a tool that i could use to do a
> diff?
>
> Thanks
> Justin
>|||You can start by checking all the table sizes ;)
Maybe somebody/changed to diffirential backup ?
Cheers,
Harry|||Yeah you are right, i dont know if i'll need it again but a trial would be a
great start. I'll look in to that product.
Thanks
Justin
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:%23YHa4cSzHHA.4476@.TK2MSFTNGP06.phx.gbl...
> You could restore a backup before the change, and a backup after the
> change, and then use a trial copy of red-gate SQL Compare (or trial
> versions of other tools), I guess. Tools like this pay for themselves in
> the long run, unless this is the only time you will ever use it (which you
> can't possibly know right now).
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "Justin Rich" <jrich523@.yahoo.spam.com> wrote in message
> news:u0yWbRSzHHA.4824@.TK2MSFTNGP02.phx.gbl...
>|||Yeah i guess i didnt really think about that. its really not too hard to run
a script to give some basic statistics about tables. More just a resource
problem but i have some spare servers i can run this on.
Thanks!
Justin
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message news:CABE43A2-BD14-4E93-89FA-D5D5C8E12393@.microsoft.com...
> You can start by checking all the table sizes ;)
> Maybe somebody/changed to diffirential backup ?
> Cheers,
> Harry
>