If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > Database Server Software > Microsoft SQL Server > SQL server 2005 database has grown big in 2 days

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Sep 2007
Posts: 6
SQL server 2005 database has grown big in 2 days

Currently the database is on SQL server 2005 Workgroup edition.
This customer had a corrupt database last week, so I backed up their db and brought the copy in office and re-built the database. On 24th, I restored the fixed db on their server that time the size of the db was 7 MB and today i.e. on 26th when I checked the size now its grown to 7 GB. I tried to shrink the data file, now the size is reduced to 5 GB. They must have posted the 2000 transactions in last 2 days.

Also, when I checked the size of the back up files (backed up by the maintenance plan), the size on 24th was 7mb, and it grew to 2GB yesterday.
Can you please tell what could be the problem here and how do I resolve it?

Thanks for help in advance
Reply With Quote
  #2 (permalink)  
Old
Annie's Dog Walker
 
Join Date: Nov 2004
Location: on the wrong server
Posts: 8,414
what recovery mode are you in and how big is the log file?

run this...

sp_helpdb PutYourDBNameHere
__________________
If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry. Earnest Hemingway, A Farewell To Arms.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Sep 2007
Posts: 6
The recovery mode is full

and the size for the log file is 1024KB.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Sep 2008
Posts: 7
Apparently service pack 1 had the following issue:

FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 with Service Pack 1

Would suggest installing SP2 if not already there...
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Oct 2008
Posts: 9
Check if U have been a shark-attack victim so that your logon Files grow.
Reply With Quote
  #6 (permalink)  
Old
Annie's Dog Walker
 
Join Date: Nov 2004
Location: on the wrong server
Posts: 8,414
Dud stop resurrecting old dead threads that the original poster has long since abandoned. its really annoying.
__________________
If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry. Earnest Hemingway, A Farewell To Arms.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On