Click here to Skip to main content
15,394,655 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Word vent... Pin
BryanFazekas19-Oct-21 1:37
MemberBryanFazekas19-Oct-21 1:37 
GeneralRe: Word vent... Pin
David O'Neil19-Oct-21 6:37
professionalDavid O'Neil19-Oct-21 6:37 
GeneralMS SQL server developer 2019 occupied 300G on my C drive Pin
Southmountain17-Oct-21 15:55
MemberSouthmountain17-Oct-21 15:55 
GeneralRe: MS SQL server developer 2019 occupied 300G on my C drive Pin
Jacquers17-Oct-21 19:06
MemberJacquers17-Oct-21 19:06 
GeneralRe: MS SQL server developer 2019 occupied 300G on my C drive Pin
Southmountain18-Oct-21 8:48
MemberSouthmountain18-Oct-21 8:48 
GeneralRe: MS SQL server developer 2019 occupied 300G on my C drive Pin
Jacquers18-Oct-21 19:58
MemberJacquers18-Oct-21 19:58 
GeneralRe: MS SQL server developer 2019 occupied 300G on my C drive Pin
Southmountain19-Oct-21 7:49
MemberSouthmountain19-Oct-21 7:49 
GeneralRe: MS SQL server developer 2019 occupied 300G on my C drive Pin
Richard Deeming17-Oct-21 22:32
mveRichard Deeming17-Oct-21 22:32 
As Jacquers said, it's probably your database files. Specifically, if you have the "recovery model" set to "full", and you're not taking regular backups of the transaction logs, they will just keep growing.

You can check the log_reuse_wait_desc column in the sys.databases management view to check for other reasons why the transaction logs might not be shrinking.
SQL
SELECT name, recovery_model_desc, log_reuse_wait_desc FROM sys.databases ORDER BY name;




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: MS SQL server developer 2019 occupied 300G on my C drive Pin
Southmountain18-Oct-21 8:25
MemberSouthmountain18-Oct-21 8:25 
GeneralAmazon doesn't trust me... Pin
PIEBALDconsult17-Oct-21 8:45
professionalPIEBALDconsult17-Oct-21 8:45 
GeneralRe: Amazon doesn't trust me... Pin
Johnny J.17-Oct-21 21:01
professionalJohnny J.17-Oct-21 21:01 
GeneralRe: Amazon doesn't trust me... Pin
Sander Rossel17-Oct-21 22:45
professionalSander Rossel17-Oct-21 22:45 
GeneralRe: Amazon doesn't trust me... Pin
trønderen18-Oct-21 2:30
Membertrønderen18-Oct-21 2:30 
GeneralRe: Amazon doesn't trust me... Pin
Matias Lopez18-Oct-21 10:58
MemberMatias Lopez18-Oct-21 10:58 
GeneralNew CCC handicapping system Pin
pkfox17-Oct-21 0:53
professionalpkfox17-Oct-21 0:53 
GeneralRe: New CCC handicapping system Pin
Greg Utas17-Oct-21 1:19
mveGreg Utas17-Oct-21 1:19 
GeneralRe: New CCC handicapping system Pin
OriginalGriff17-Oct-21 1:52
mveOriginalGriff17-Oct-21 1:52 
GeneralRe: New CCC handicapping system Pin
pkfox17-Oct-21 3:26
professionalpkfox17-Oct-21 3:26 
GeneralRe: New CCC handicapping system Pin
OriginalGriff17-Oct-21 3:50
mveOriginalGriff17-Oct-21 3:50 
GeneralRe: New CCC handicapping system Pin
jsc4217-Oct-21 22:13
professionaljsc4217-Oct-21 22:13 
GeneralRe: New CCC handicapping system Pin
DRHuff17-Oct-21 6:55
MemberDRHuff17-Oct-21 6:55 
GeneralRe: New CCC handicapping system Pin
pkfox17-Oct-21 10:27
professionalpkfox17-Oct-21 10:27 
JokeBut we all know the final score... Pin
Kornfeld Eliyahu Peter16-Oct-21 20:03
professionalKornfeld Eliyahu Peter16-Oct-21 20:03 
GeneralRe: But we all know the final score... Pin
RickZeeland16-Oct-21 20:32
mveRickZeeland16-Oct-21 20:32 
GeneralRe: Top Level Message Pin
User 1535920316-Oct-21 10:44
MemberUser 1535920316-Oct-21 10:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Straw Poll

Do you feel you fully understand the vision and purpose of the software project you're working on?
Sure you can be told the "what", but do you have the "why"?
  Results   292 votes