WikiWirral Wirral's Biggest Online Forum
Forum Statistics
Forums65
Topics76,499
Posts1,034,117
Members14,886
Most Online80,173
Apr 25th, 2025
Who's Online Now
7 members (2 invisible), 3,366 guests, and 365 robots.
Key: Admin, Global Mod, Mod
Top Posters
sunnyside 45,164
MattLFC 22,315
Mark 21,269
granny 17,811
_Ste_ 16,347
Newest Members
Littlehaven22, BluePeter, David_Roberts, PostNB, Gemnm
14,886 Registered Users
New General Forums
Bridge Street Hostel - 1980’s
by Jmac267 - 20th Jul 2025 12:55pm
Cammell Laird Film - Old Ships & Hardships
by David_Roberts - 16th Jul 2025 5:03pm
Cammell Laird Film - Old Ships & Hardships
by David_Roberts - 16th Jul 2025 5:00pm
Subscriptions to posts?
by nickaxe - 5th Jul 2025 12:33pm
New Wirral History
Hoylake Parade School tragedy
by chris58 - 16th Jul 2025 5:30pm
Removed Mother from Grave
by bert1 - 29th Jun 2025 6:44am
White House, Childer Thornton
by NickWirral - 23rd Dec 2022 1:19pm
Top Posters(30 Days)
bert1 11
Topic Replies
What are they doing at four bridges?
by Excoriator - 25th Jul 2025 12:23pm
New Ferry regeneration
by diggingdeeper - 24th Jul 2025 5:10am
Bultaco pursang
by BultacoAstro - 23rd Jul 2025 6:23pm
Family Alldis
by diggingdeeper - 22nd Jul 2025 5:19pm
Bridge Street Hostel - 1980’s
by Jmac267 - 20th Jul 2025 12:55pm
Pay and Display ... Or Not.
by diggingdeeper - 19th Jul 2025 11:07am
Mobile Welder Wanted
by Grosvenor - 17th Jul 2025 6:46pm
July
M T W T F S S
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31
Top Likes Received (30 Days)
ap493 1
bert1 1
Philip 1
Top Likes Received
bert1 29
casper 4
Mark 4
Previous Thread
Next Thread
Print Thread
#155425 11th May 2007 2:12pm
Joined: Nov 2003
Posts: 3,793
AX_125 Offline OP
Forum Guardian
OP Offline
Forum Guardian
Joined: Nov 2003
Posts: 3,793
I have a database that was setup far before my time in my current employment. The log file has grown to 40GB, i have set limits on it to stop it growing any more. I really need to shrink this log file quite consideribly. The database has a full backup every week and an incremental backup every night.

My knowledge of MS SQL server isn't amazing, but i was under the impression this might purge the logfiles like it does with MS Exchange when that is backed up.

The database is only about 300mb and is currently only used for reference. Should i delete the log file and start again with restricted log file sizes?


[Linked Image]
I am a signature virus, copy me into your signature to help me spread.
Google Ads
AX_125 #155429 11th May 2007 2:59pm
Joined: Nov 2003
Posts: 12,002
Wiki Master
Offline
Wiki Master
Joined: Nov 2003
Posts: 12,002
Can you not create a cron to purge the old files at the end of each day?


What If There Were No Hypothetical Questions?
StuyMac #155436 11th May 2007 4:35pm
Joined: Nov 2003
Posts: 3,793
AX_125 Offline OP
Forum Guardian
OP Offline
Forum Guardian
Joined: Nov 2003
Posts: 3,793
Already tried that frown


[Linked Image]
I am a signature virus, copy me into your signature to help me spread.
StuyMac #155437 11th May 2007 4:39pm
Joined: Nov 2003
Posts: 21,269
Likes: 4
Wiki Master
Offline
Wiki Master
Joined: Nov 2003
Posts: 21,269
Likes: 4
Is this on a windows or Linx Server as they can behave different even if its the same version of mysql.

As there log files, i assume for tracking,
you should be able to back them up, and then delete them.

As you say starting a fresh with a max log size.

I don't know for sure as the versions and platform can be important.

But even if you answer those questions, i don't think i could
give you a 100% Answer.

Don't forget, if its not broken dont fix it wink

Mark #155441 11th May 2007 5:03pm
Joined: Nov 2003
Posts: 3,793
AX_125 Offline OP
Forum Guardian
OP Offline
Forum Guardian
Joined: Nov 2003
Posts: 3,793
windows 2000

Well, the disk is 60GB and this log is 45gb. I have now stopped the log from growing any more, there is not enough space to back it up locally. I am doing an online backup this weekend. Hopefully this might do it.


[Linked Image]
I am a signature virus, copy me into your signature to help me spread.
AX_125 #155445 11th May 2007 5:31pm
Joined: Aug 2004
Posts: 22,315
Likes: 1
Wiki Master
Offline
Wiki Master
Joined: Aug 2004
Posts: 22,315
Likes: 1
Originally Posted by Mark
Is this on a windows or Linx Server as they can behave different even if its the same version of mysql.

MSSQL is Windows NT only hence the name Microsoft SQL, and has very little to do with MySQL and absolutely nothing to so with Linux. The same as ASP. Talking about MySQL in a topic that is about MSSQL is just confusing matters.

As much as I work with servers I havent a clue about MSSQL lmao! Linux all the way for me unfortuantly sorry I cant offer much help.

wink

MattLFC #155449 11th May 2007 5:50pm
Joined: Nov 2003
Posts: 21,269
Likes: 4
Wiki Master
Offline
Wiki Master
Joined: Nov 2003
Posts: 21,269
Likes: 4
1 log file of 45gb omg

Sorry i cant help, as MYSQL is where i have more knowledge.

Let us know how you get on, if you would,
you never know when it may come in handy.

Sorry i looked too quick, as i work with mysql my eyes
seen mysql and not mssql.

Mark #155454 11th May 2007 5:58pm
Joined: Aug 2004
Posts: 22,315
Likes: 1
Wiki Master
Offline
Wiki Master
Joined: Aug 2004
Posts: 22,315
Likes: 1
Lol easy enough mistake to make to be honest.

MattLFC #156100 18th May 2007 10:26am
Joined: Nov 2003
Posts: 3,793
AX_125 Offline OP
Forum Guardian
OP Offline
Forum Guardian
Joined: Nov 2003
Posts: 3,793
Solution, for anyone that is interested

1.DBCC SHRINKFILE(Pubs_log, 100)

2.BACKUP log Pubs WITH TRUNCATE_ONLY

3.DBCC SHRINKFILE(Pubs_log, 100)



[Linked Image]
I am a signature virus, copy me into your signature to help me spread.

Moderated by  Mark 

Link Copied to Clipboard
Random Wirral Images

Click to View Topic.
Newest Topics
What are they doing at four bridges?
by Excoriator - 25th Jul 2025 12:23pm
Bridge Street Hostel - 1980’s
by Jmac267 - 20th Jul 2025 12:55pm
Pay and Display ... Or Not.
by diggingdeeper - 18th Jul 2025 12:53am
Mobile Welder Wanted
by Grosvenor - 17th Jul 2025 6:46pm
Hoylake Parade School tragedy
by chris58 - 16th Jul 2025 5:30pm
For Sale & Free
Member Spotlight
diggingdeeper
diggingdeeper
Wirral
Posts: 14,524
Joined: July 2008
Today's Birthdays
There are no members with birthdays on this day.
New Wirral Info
What are they doing at four bridges?
by Excoriator - 25th Jul 2025 12:23pm
Pay and Display ... Or Not.
by diggingdeeper - 18th Jul 2025 12:53am
Family Alldis
by Alldis - 2nd Jul 2025 6:15pm
News : New Topics
Cammell Laird Film - Old Ships & Hardships
by David_Roberts - 16th Jul 2025 5:02pm
New Ferry regeneration
by Excoriator - 16th Mar 2025 4:22pm
Lucy Letby
by diggingdeeper - 16th Dec 2024 7:16pm
New Enthusiast Forums
Mobile Welder Wanted
by Grosvenor - 17th Jul 2025 6:46pm
Bultaco pursang
by Bultaco - 13th Mar 2019 1:43pm
Popular Topics(Views)
10,442,936 CW Chat room thread
5,675,291 WIKI WALK CHAT
4,489,589 Spotted!
Powered by UBB.threads™ PHP Forum Software 7.7.5