|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > DB DiskSpace Problem
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 |
DB DiskSpace Problem
|
|
|
| Hi friends,
I am newbie on SQL2000 . Our data is on D 68GB) drive and its already
nearest full disk . it has jst 6mb empty space on it. I want to get more
space on D: drive . I want to delete some records, to do that but i dont
know how can i do.
Thanks for helps.
| |
|
| Before you go deleting data just yet, why dont you see how much space the
tlog is consuming. Rclick the db in Enterprise Manager/ props/ tlog.
"erdem" <ealkan@milliyet.com.tr> wrote in message
news:OlUnxLIPCHA.1724@tkmsftngp13...
> Hi friends,
> I am newbie on SQL2000 . Our data is on D68GB) drive and its already
> nearest full disk . it has jst 6mb empty space on it. I want to get more
> space on D: drive . I want to delete some records, to do that but i dont
> know how can i do.
> Thanks for helps.
>
>
| |
| [MS] Eric Yang 2002-08-06, 9:23 pm |
| Hello,
In addition to the above option, first you have to check whether the data
increment is just what you expected. That is to say, if you set the size of
the database files is no limited and more and more data are inserted into
the database, the increment is normal.
In addition, if you want to shrink the size of the data files, you can also
use 'DBCC SHRINKDATABSAE' to free more space.
If the increment size of the database is due to the large log files, you
can also consider shrink the log file to free the space.
Please refer to the following article for more information about how to
shrink the log file.
http://support.microsoft.com/suppor...s/q272/3/18.asp
Sincerely,
Eric Yang [MS]
Microsoft Online Support Engineer
Please do not send email directly to this alias. This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security
|
|
|
|
|