Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Backup files smaller all of a sudden

  Asked By: Sheldon    Date: Dec 05    Category: Sharepoint    Views: 898

I recently read an article about how you can compact the sharepoint database
and that was neat. However, all I did was *read* the article. I didn't
take any steps whatsoever, I swear!

So I get in today and see my backups:

U:\>dir \\go\F$\SPS-BACK <file://\\go\F$\SPS-BACK>
Volume in drive \\go\F$ <file://\\go\F$> is Data
Volume Serial Number is C450-7F7A

Directory of \\go\F$\SPS-BACK <file://\\go\F$\SPS-BACK>

08/29/2002 04:30a <DIR> .
08/29/2002 04:30a <DIR> ..
08/28/2002 04:38a 4,438,374,237 backup.1
08/27/2002 04:37a 4,436,727,690 backup.2
08/26/2002 04:37a 4,427,499,210 backup.3
08/25/2002 04:37a 4,432,790,532 backup.4
08/24/2002 04:37a 4,427,531,089 backup.5
08/29/2002 04:35a 3,855,526,730 backup.bak
6 File(s) 26,018,449,488 bytes
2 Dir(s) 100,766,605,312 bytes free

Notice the dates. From 8/24 to 8/28, the size of the backup is mostly
getting larger each day (except for 8/25->8/26). However, last night's
backup is *way* smaller than the previous (600KB smaller).

Is this normal? Anyone else see this?



5 Answers Found

Answer #1    Answered By: Shailendra Shinde     Answered On: Dec 05

I have seen this in my backups as well. I just figured people were removing
files, webparts, etc.

Answer #2    Answered By: Yessenia Dejesus     Answered On: Dec 05

If I remember correctly( and I can not remember where I read  this) SPS
WSS does a defrag automatically. I wonder if this is what happened. Do
you happen to know the url to the article  on compacting?

Answer #3    Answered By: Randolph Charles     Answered On: Dec 05

Be careful. This might be nothing but the last time my backups got smaller I
couldn't restore it anymore. Hopefully you have a test machine with SPS that
you can try a restore on. Better safe than.....

Answer #4    Answered By: Kavi Kumhor     Answered On: Dec 05

Sorry. I did a test restore and all worked fine.

Answer #5    Answered By: Alex Davis     Answered On: Dec 05

Yes, SPS does a nightly webstore maintenance just like E2K does a
nightly webstore maintenance. Part of that is online defrag.

Didn't find what you were looking for? Find more on Backup files smaller all of a sudden Or get search suggestion and latest updates.