473,406 Members | 2,713 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Increasing Database Size

Hi,

Please help me to solve this problem. My database size is 8 GB , 5GB of data file and 3GB of log file. I increased the size of datafile to 10GB and log file to 3.5 GB with 11GB and 4GB by 20 MB autogrowth. After increasing i checked the data file using sp_spaceused and it was 10 GB.But after 30-45 minutes, when i check the database size, it has reduced to 5GB and 3GB. But the autogrowth is 11GB and 4GB.I am not able to increase the intial size.I dont know what is wrong. I have disk space of more than 25GB.

Can anybody please suggest me what is going wrong here.
Aug 15 '07 #1
6 2130
Purple
404 Expert 256MB
Hi sandyboy,

What version of MSSQL server are you running ?

Answer for SQL 2000 - If you have autoshrink set on for the database, all of the database files are candidates for periodic shrinking. This applies to both data and log files. The log files will shrink at the point the log is backed up or trucated.

I am assuming the same behavior under 2005 but would need to check..

Purple
Aug 15 '07 #2
Purple
404 Expert 256MB
Hi Sandyboy,

to preempt the next question, in enterprise manager, rightclick on the database, select the options tab and untick autoshrink.

Let us know if this does the trick

Kind Regards

Purple
Aug 15 '07 #3
Thanks Purple for replying. Let me try this and get back to you.

This is unusual. My server machine is SQL 2000 and the client machine is SQL 2005.I hope thats why i have problem.
Aug 15 '07 #4
Purple
404 Expert 256MB
Hi Sandyboy,

I have just checked my SQL2005 server and :

right click database => properties => options vertical tab => auto shrink

options are now true or false, appears to be false by default..

Regards Purple
Aug 15 '07 #5
Hi Purple,

Thanks for your advice. I had once changed autoshrink to true. But now i changed to false and increased the size.Its been more than 2 hours and i think its has not changed to 8gb again. Its 11GB. So i think it worked. But i am planning to observe the whole day. If it does not roll back to 8GB, then it is solved. Once again thanks for your sincere follow-up.
Aug 15 '07 #6
Purple
404 Expert 256MB
Hey Sandyboy,

We are here to help - am pleased you appear to have solved the problem, I look forward to seeing you around in the future.

Regards Purple
Aug 15 '07 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

22
by: Bryan Rickard | last post by:
I wrote a simple program in VB6 to copy all the files from a directory on a CD-ROM to my hard disk. There are about 10 files, each about 30MB. The program uses Get and Put to get data from the...
7
by: enigma | last post by:
Just wondering if you could help me on this one. I'm not sure if my transaction logs are behaving oddly or what. I've successfuly managed to shrink my transaction logs from 7GB down to 1MB and now...
5
by: Good Man | last post by:
Hi everyone I'm using the "MySQL Administrator" program to keep tabs on the health of a web system i am developing. I think it's nice to have quick (gui) feedback on the query cache, memory...
5
by: DaveA | last post by:
I've got myself into a bind here. Any help would be a life saver. I created a form with 644 text boxes that serve as "days" for a schedule. Each text box has a code which is populated with an X or...
3
by: Nick | last post by:
I have found a class that compresses and uncompresses data but need some help with how to use part of it below is the deflate method which compresses the string that I pass in, this works OK. At...
15
by: Joe Lester | last post by:
I installed Postgres 7.4.1 on a dual processor G5 running Mac OS 10.3.2. I'm trying to increase the max_connections to 300 and running into some trouble. If anyone could shed some light, I'd...
4
by: Rahul B | last post by:
Hi, I was getting the error: sqlcode: -911 sqlstate: 40001 , which is "The maximum number of lock requests has been reached for the database." So i increased the locklist size to 200 from the...
0
by: wajedali | last post by:
hi......... i have problem in incresing and decreasing the component. I have a one main panel (i.e. i used as _basewindowPanel) in that again two panel in that two panel like wise.... ...
4
by: =?Utf-8?B?cmFuZHkxMjAw?= | last post by:
Visual Studio 2005, C# WinForms application: Here’s the question: How can I increase the standard 1 MB stack size of the UI thread in a C# WinForms application? Here’s why I ask: I’ve...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.