|
Home > Archive > Microsoft Content Management Server > April 2006 > Clear Revision History Increases size of Database.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Clear Revision History Increases size of Database.
|
|
| Mukunda 2006-04-18, 12:48 am |
| I have a database of size 36mb.
I had a backup of the database taken 10 days back.
I cleared the history(mentioned the date of db backup) via site manager
and when i see the database size after this, its 38mb.
When i see the Revision history in edit mode, all revisions before the
date for which i've cleared were not shown.
I have almost same number of revisions before and after the date of
backup.
Why does the database size increase after clearing history?
| |
| Stefan [MSFT] 2006-04-27, 7:27 am |
| Hi Mukunda,
is this the physical size of the database or the data in the database?
The physical size of the database files might not shrink. But it might be
that only a smaller percentage of the DB is used.
You might need to use SQL tools to shrink the DB.
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------
"Mukunda" <manoj.mauryan@gmail.com> wrote in message
news:1145262651.129178.259640@t31g2000cwb.googlegroups.com...
>I have a database of size 36mb.
> I had a backup of the database taken 10 days back.
> I cleared the history(mentioned the date of db backup) via site manager
> and when i see the database size after this, its 38mb.
> When i see the Revision history in edit mode, all revisions before the
> date for which i've cleared were not shown.
> I have almost same number of revisions before and after the date of
> backup.
> Why does the database size increase after clearing history?
>
| |
| Mukunda 2006-04-27, 7:27 am |
| Stefan,
That is the size of the data in the database.
Stefan [MSFT] wrote:[vbcol=seagreen]
> Hi Mukunda,
>
> is this the physical size of the database or the data in the database?
> The physical size of the database files might not shrink. But it might be
> that only a smaller percentage of the DB is used.
> You might need to use SQL tools to shrink the DB.
>
> Cheers,
> Stefan
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> New to MCMS?
> Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
> Check out the new book as well: Advanced MCMS development:
> http://tinyurl.com/8ugwj
> ----------------------
>
>
> "Mukunda" <manoj.mauryan@gmail.com> wrote in message
> news:1145262651.129178.259640@t31g2000cwb.googlegroups.com...
| |
| Stefan [MSFT] 2006-04-27, 7:27 am |
| Hi Mukunda,
please ensure that the SQL background processing job has run.
This job will do the final clean up.
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------
"Mukunda" <manoj.mauryan@gmail.com> wrote in message
news:1145426102.905251.204990@i40g2000cwc.googlegroups.com...
> Stefan,
>
> That is the size of the data in the database.
>
> Stefan [MSFT] wrote:
>
|
|
|
|
|