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 |
|
miniapa
Starting Member
1 Post |
 Posted - 2012-01-14 : 15:06:33
|
| Hi im new in this forum.. I work in a hospital in colombia and we use Sql server 2008 R2 with an applicacion called cnt that its used by our doctors and all the workers from the hospital.Ive been having a problem with my db... My DB space is 15 G.. From like two days my DB and log is been increiseng like crazy... the normal space is 15 G but the DB and the log are growing crazy and went even to 30 G almost the double from the normal space... When Its so big.. I have to reduce the log first.. then i have to disconnecte everybody from the Sql server and then run the reduce the DB from the commands that appear in Sql.. After waiting a lot for this happen the DB comes to the original space 15 G... I been having this problem from the last 3 Days... Does Anybody know how to resolve this problem... Im goin crazy with this... Thanks from colombia. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-14 : 15:51:40
|
| First thing - log managementPlease read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Problem with DB