Does full backup shrink .mdb file?

[Crowley16]

Sql server 2005.

I did a big delete on a database a couple of days ago, and the size of the database didn't really go down much, nor did the size of the full backup of the database.

I was planning to manually run a shrink today and a index rebuild, however I notice that today all the space seems to have been recovered.

The thing is, I don't immediately see any jobs which specifies this free space recovery and the only likely one I do see is the full backup.

So is the full backup automatically removing the unused space in my live .mdb file or is there another job running somewhere which I don't see?

thanks

--------------------
Procrastinate Now!

 

[ptheriault]

No a full backup will not shrink the database. do you have the auto shrink option set in the database?

- Paul
- If at first you don't succeed, find out if the loser gets anything.