WikiWirral is where great friendships are made.
Forum Statistics
Forums65
Topics76,352
Posts1,033,281
Members14,560
Most Online16,551
Feb 2nd, 2024
Who's Online Now
7 members (3 invisible), 8,175 guests, and 438 robots.
Key: Admin, Global Mod, Mod
Top Posters
sunnyside 45,164
MattLFC 22,315
Mark 21,269
granny 17,788
_Ste_ 16,345
Newest Members
Kalena1962, rattus, Lisrush, Emotecreative, ArranGirl13
14,560 Registered Users
New General Forums
New Wirral History
Tall Brick Chimneys
by diggingdeeper - 16th Mar 2024 11:56am
D.I.Y. / Building Shop
by mharford91 - 3rd Mar 2024 8:53pm
1970's Murder in Central Park, Wallasey
by cutespam - 4th Aug 2018 10:28am
Old Hall in Higher Bebington
by Rhoobarb - 25th May 2010 5:55pm
Oleo Works
by Ducko - 14th May 2008 3:09pm
Top Posters(30 Days)
granny 14
casper 13
bri445 4
Topic Replies
What song are you listening to?
by diggingdeeper - 28th Mar 2024 6:06pm
Facial recognition coming in supermarkets?
by diggingdeeper - 27th Mar 2024 3:50pm
Bolts at Bebington Road
by diggingdeeper - 27th Mar 2024 2:33am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Tall Brick Chimneys
by diggingdeeper - 26th Mar 2024 5:43pm
Lost river (Well, brook really)
by diggingdeeper - 26th Mar 2024 3:09am
Old Hall in Higher Bebington
by diggingdeeper - 24th Mar 2024 5:58pm
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Wisper electric bike. 36v .
by Dilly - 21st Mar 2024 7:36pm
March
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)
cools 1
Kylix 1
Top Likes Received
bert1 14
Mark 4
Gibbo 3
Previous Thread
Next Thread
Print Thread
#155425 11th May 2007 1: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 1: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 3: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 3: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 4: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 4:31pm
Joined: Aug 2004
Posts: 22,315
Wiki Master
Offline
Wiki Master
Joined: Aug 2004
Posts: 22,315
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 4: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 4:58pm
Joined: Aug 2004
Posts: 22,315
Wiki Master
Offline
Wiki Master
Joined: Aug 2004
Posts: 22,315
Lol easy enough mistake to make to be honest.

MattLFC #156100 18th May 2007 9: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
Facial recognition coming in supermarkets?
by Excoriator - 27th Mar 2024 10:52am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Bolts at Bebington Road
by Excoriator - 23rd Mar 2024 9:48am
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Tall Brick Chimneys
by diggingdeeper - 16th Mar 2024 11:56am
For Sale & Free
Wisper electric bike. 36v .
by Dilly - 21st Mar 2024 7:36pm
This is Elvis
by GingerTom - 17th Mar 2024 2:37pm
Member Spotlight
KevinFinity
KevinFinity
Wirral
Posts: 2,354
Joined: April 2009
Today's Birthdays
There are no members with birthdays on this day.
New Wirral Info
Facial recognition coming in supermarkets?
by Excoriator - 27th Mar 2024 10:52am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Bolts at Bebington Road
by Excoriator - 23rd Mar 2024 9:48am
Get your Money Tree ready
by keef666 - 22nd Mar 2023 12:27pm
Restaurant/pub with outdoor seating - Bromborough
by CarterUSM - 7th Aug 2020 7:59pm
News : New Topics
Gaza
by diggingdeeper - 29th Oct 2023 9:28am
Lost river (Well, brook really)
by Excoriator - 10th Sep 2019 8:50am
New Enthusiast Forums
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Xbox
by TudorBlue - 3rd Mar 2024 8:48pm
Wiper mechanism needed
by Peter0787 - 20th Feb 2024 4:07pm
What song are you listening to?
by - 24th Jun 2007 9:06am
Popular Topics(Views)
5,069,775 WIKI WALK CHAT
4,013,851 Spotted!
Powered by UBB.threads™ PHP Forum Software 7.7.5