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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-07 : 08:50:54
|
| Real writes "Hi, My database is growing everyday even thought we are barely adding data. I used the shrink functionnality but nothing is happening. Can I do a dump and reload ? Is there's other way to shrink the database ?ThanksReal" |
|
|
CanadaDBA
583 Posts |
Posted - 2005-01-07 : 09:07:54
|
| I think SQL-Server needs a certain amount space in the DB, so it creates the space even after shrink! And I have learnt to not shrink a DB on a daily basis.Canada DBA |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-01-08 : 07:07:31
|
| "My database is growing everyday"What are you using to define the size? If its the size of the .LDF file, rather than the .MDF file, then the likely reason is that you have the RECOVERY MODEL set to FULL and you are not doing transaction log backups.If that's the case eithera) Do transaction log backupsorb) Change the Recovery Model to SIMPLE (Database Properties in Enterprise manager)You need to do (a) if you need to be able to recover to a point-in-time between full backups. If being able to restore to your last full/differential backup (which is probably daily or weekly) is good-enough then use (b)If that's not the answer! then please post how you are determining Database SizeKristen |
|
|
|
|
|
|
Shrink Database