Re: Andrew J. Kelly please
From: Hassan (fatima_ja_at_hotmail.com)
Date: 07/19/04
- Next message: Hari Prasad: "Re: db stuck on loaded status"
- Previous message: Neil: "upgrade 7.0 to 2000"
- In reply to: john: "Andrew J. Kelly please"
- Next in thread: Andrew J. Kelly: "Re: Andrew J. Kelly please"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 09:56:34 -0700
Im not Andrew Kelly, but up until he replies, take a loot at DBCC Shrinkfile
and have your data files in there as parameters.
"john" <john@aic.com> wrote in message
news:un9R5ZabEHA.3752@TK2MSFTNGP12.phx.gbl...
> Since you are so helpful, here is another question regarding my original
> post yesterday:
>
> ********************************************************************
> My database has one data file only, and the data file was 900M of data
after
> I ran DBCC SHRINKDATABASE(DBName). But I wanted to give it 10% free space
so
> it does not have to expand in a while; I ran DBCC
> DBREINDEX(TableName,N'',90) on all of my user tables (all tables have
> clustered index). I was expecting the database to expand 900 X 10% = 90M.
> However, when it completed, the data file became 1.9G in total. When I
view
> the database from EM (taskpad view), looks like 50% free space. Why?
Thanks.
> ********************************************************************
>
> Question:
>
> I actually have 100+ such databases on the server and it is running out of
> space. I would like to somehow get some free space back to OS (leaving
> 10-20% of free space in data files instead of 50% right now). And we also
> want to re-org data files as we have lots of insert/delete/updates going
on
> daily. Since DBCC DBREINDEX will not release free space, what are my
> options? I don't care about log file growth as they are in seperate RAID
> with plenty of spaces. Thank you very much.
>
> John
>
>
>
>
- Next message: Hari Prasad: "Re: db stuck on loaded status"
- Previous message: Neil: "upgrade 7.0 to 2000"
- In reply to: john: "Andrew J. Kelly please"
- Next in thread: Andrew J. Kelly: "Re: Andrew J. Kelly please"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
