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 |
|
BSLillo
Starting Member
9 Posts |
 Posted - 2006-02-13 : 03:28:19
|
| Hello everyone!Someone knows in what way could I compact my Database, log file e and Data file? I'm using MS SQL Server 2000 and when i try to compact my Db, it works but the size it seems to be the same of the original!What is the correct way to manage the log file generated by the Db and to control the grow of it?Thank you very much!!! |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-02-13 : 03:39:58
|
| There's little point in shrinking your data or log files if your production activity means that they will grow back again afterwards. You'll just be imposing load on SQL Server to grow the files again when it needs to. If you don't need point in time recovery you can change the database recovery model to "simple" and this will keep your log file size as minimal as possible. Invest in larger disks.-------Moo. :) |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-02-13 : 03:52:38
|
or backup your log files regularly to control the growth --------------------keeping it simple... |
|
|
|
|
|
|
My DB grows to much!!!