|
I used a free tool to check the file size and find the SQL log file folder is with the biggest size:
5.| PATH: Program Files\Microsoft SQL Server\MSSQL15.Peaker\MSSQL\Log | SIZE: 346.30 Gb | DEPTH: 5
how to shrink these log folder size?
diligent hands rule....
|
|
|
|
|
Checking table sizes in a database:
DECLARE @str VARCHAR(500) SET @str = 'exec sp_spaceused ''?''' EXEC sp_msforeachtable @command1=@str
Shrinking the database and logs:
ALTER DATABASE [database name] SET RECOVERY SIMPLE WITH NO_WAIT;
DBCC SHRINKFILE('database name', 1);
ALTER DATABASE [database name] SET RECOVERY FULL WITH NO_WAIT;
|
|
|
|
|
thank you for your tips! I learned new things from you.
I think I find the reason: my PolyBase feature is not installed correctly, so it caused SQL server keep dumping big files.
Now I fixed this problem.
diligent hands rule....
|
|
|
|
|
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.
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
|
|
|
|
|
I run this query and here is my result:
Name recovery_model_desc log_reuse_desc
AdventureWorks SIMPLE NOTHING
master SIMPLE NOTHING
model FULL NOTHING
msdb SIMPLE NOTHING
tempdb SIMPLE NOTHING
Do I have any issue with these tables?
diligent hands rule....
|
|
|
|
|
"If you're still lying with your payment, we recommend that you contact your credit card issuer."
"Lying"? Me? Noooo...
|
|
|
|
|
Well, what can I say? Amazon seems to know their customers VERY well...
Anything that is unrelated to elephants is irrelephant Anonymous
- The problem with quotes on the internet is that you can never tell if they're genuine Winston Churchill, 1944
- Never argue with a fool. Onlookers may not be able to tell the difference. Mark Twain
|
|
|
|
|
Well, I couldn't be bothered to stand up
|
|
|
|
|
Do you happen to be from Crete?
You know, behind every paradox lies a Cretan.
|
|
|
|
|
All of these paywebs & third's, a piece of bullsh&t!!!
|
|
|
|
|
Have we come to a conclusion yet ? I think it will be difficult to police for several reasons:-
1) Who decides who will be handicapped
2) At what point do you stop being handicapped.
3) At what point do you stop benefiting from a handicap.
4) It's only a bit of fun.
Thoughts peeps ?
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Agreed. Something that hasn't even been mentioned is that by the time someone in UTC-5 sees it, it's usually been solved if it's going to be solved at all. But given that most of the non-UK participants are in Oz, I wouldn't ask for this to change. Moving it to noon UTC, for example, would put it at 10pm in eastern Oz.
|
|
|
|
|
Results won't be in until Tuesday: The Lounge[^] as it was late on a Friday when it was suggested.
But ... the results are 100% "for" handicapping so far. I haven't voted yet as I suspect that if it does get in it'll end up with more work for me and I'm against that on general principles.
Policing? Dunno. If we decide it's needed, I'll think about it.
(4) is pretty important, I think!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I voted yes initially, but having thought some more I think we should leave it as it is and just ban me and you from the competition
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Well it has the advantage of being easy to police ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: Policing? Dunno. If we decide it's needed, I'll think about it.
(4) is pretty important, I think!
Agree re (4) - that should be the guiding principle
I had not considered 'policing' when I made the suggestion (and it was just a suggestion). I had assumed that CPers were honourable people who would just do what was intended without needing any oversight. Obviously, they could forget, but that's OK.
Sorry to have opened a can of worms!
|
|
|
|
|
|
Yes I think just leave it be
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
|
|
Message Closed
modified 13-Nov-21 21:01pm.
|
|
|
|
|
And here an answer
modified 13-Nov-21 21:01pm.
|
|
|
|
|
And you are what's called a "troll".
|
|
|
|
|
And you don't get the point
modified 13-Nov-21 21:01pm.
|
|
|
|
|
Oh, I'm pretty sure it's not me who doesn't get the point.
|
|
|
|