Usually databases allocate HD-space in chunks. I doesnt expand in size per record you add. When you are close to filling your designated HD-space, the DB automaticly expands to a new chunk of your harddrive. As a result of that, it doesnt automaticly downsize its "reserved db-space" when you delete a whole bunch of records.
But if you've set your SQLserver to AutoShrink, it should automaticly reduce its size to the nearest available chunk. Anyway, try to see if there is a manual "pack & reindex"-kinda function somewhere in one of the toolbars.
Funny (or not), I did actualy created a Maintainence plan in order to take backup and check integrity, I somehow managed to skip the "reorginize" part.
free space restored :-) kennethrisum, pls make a "svar".
You have both been helpful!
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.