Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vdang2003
Starting Member
2 Posts |
 Posted - 2007-01-11 : 15:30:41
|
(Please Rush)Hi all,I am using SQL SERVER 2000 now, and my SERVER is still have about 27 GB but in my database is saying only 3.4 MB left, I was trying to shrink my database but it is still did not give me more space.Do you know any way could help me to extend more spaces for my database?I also included the picture so could help you more Thank you very muchvdang (vdang2003@sbcglobal.net) |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-11 : 15:58:36
|
In Enterprise Manager, right click the database and click on Properties. Go to the Data Files tab. There you can see the growth specs for each file. If the database file is set to grow automatically then you have nothing to worry about, when the database needs more space the file will grow - otherwise you can specifically control the file size.The point is that you don't need to manually add space - when the database needs more space it will get it automatically unless you turn that off.And by the way - since we all offer our help for free in our spare time on this forum, we cannot rush or treat your requests as urgent.  |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-01-11 : 16:32:39
|
I try to make sure I never answer posts that are marked urgent.  CODO ERGO SUM |
|
|
|
vdang2003
Starting Member
2 Posts |
Posted - 2007-01-11 : 16:47:53
|
First of all,Thank you for your reply, I got your idea and I did follow your instruction. Here is the picture I was setup before I asked you. But I got the problem when I run daily DTS package, SQL Database tell me, I don't have enough space for that operation, so I went to server room and check it out. Finally, I found the server still have about 27 GB, and my Database already used 43 GB.So, what is your opions? (More information, in my DTS package, I import some txt files and process them, so the process did not work this morning?)Please help,Thank you for your support,Vinh Dang |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-11 : 17:13:08
|
| Your images aren't coming through so I cannot see the setup you are using. |
|
|
|
|
|
|
|
|
How to Give More Space for my SQL Database