Our Success is in our members who value our strength as a valued community.
Forum Stats
12328 Members
65 Forums
73254 Topics
989074 Posts
33 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
85 registered (alan128, 13 invisible), 1404 Guests and 267 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Finsbury Park mosque. 915
Round the Wirral with a movie camera[1934] 423
Code reader 311
Washing machine 174
Range Rover P38A Air Suspension Help Needed 120
Loving Home Wanted For 3 Cats. 110
Ant and Dec 90
Shotwick - Old And New (Hall and Solar Farm) 75
Another Scam 67
Wanted roof box 62
New General Forums
Ant and Dec
by cools
18th Jun 2017 2:11pm
Another Scam
by Excoriator
18th Jun 2017 10:00am
Happy birthday Ste
by Dilly
12th Jun 2017 7:54am
Happy birthday Neddy
by Dilly
10th Jun 2017 11:06am
New Wirral History
Round the Wirral with a movie camera[1934]
by snowhite
16th Jun 2017 2:03pm
Bascule Bridge
by Sufee
6th Jun 2017 9:09pm
Pathe news short - merseytunnel 1934
by oldpm01
5th Jun 2017 1:57pm
1878 Post Office Directory of Cheshire query
by derekdwc
1st Jun 2017 10:41pm
Bakery at 275 Poulton Road 1925 onwards
by JAFitz
30th May 2017 8:59pm
Forum Tips
Photo Gallery Forums
wirral from Liverpool big wheel
New Brighton Big Wheel
Topic Replies
Suspended sentence for 37,000 benefit fraud mum
by Fairz87
Today at 01:31 PM
What song are you listening to?
by granny
Today at 10:18 AM
live webcam from africa, a must see
by granny
Today at 09:49 AM
VW t4 fixed side window replacement
by Mike72
Today at 08:00 AM
Sailing volunteers
by diggingdeeper
Today at 12:34 AM
Finsbury Park mosque.
by fish5133
Yesterday at 11:48 PM
Bromborough Central Power Station
by Jimbo620
Yesterday at 07:19 PM
Range Rover P38A Air Suspension Help Needed
by Martin1943
Yesterday at 07:18 PM
Washing machine
by Snodvan
Yesterday at 07:08 PM
June
M Tu W Th F Sa Su
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
Recent Posts : What's On ?
Shotwick - Old And New (Hall and Solar Farm)
by diggingdeeper
18th Jun 2017 11:41am
Sefton Park
by diggingdeeper
17th Jun 2017 7:28pm
Topic Options
Rate This Topic
#155425 - 11th May 2007 2:12pm MSSQL
AX_125 Offline

Forum Guardian

Registered: 10th Nov 2003
Posts: 3793
Loc: Home
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?
_________________________

I am a signature virus, copy me into your signature to help me spread.

Top
Google Ads
#155429 - 11th May 2007 2:59pm Re: MSSQL [Re: AX_125]
StuyMac Offline

Wiki Master

Registered: 24th Nov 2003
Posts: 12002
Loc: Wirralshire
Can you not create a cron to purge the old files at the end of each day?
_________________________


What If There Were No Hypothetical Questions?

Top
#155436 - 11th May 2007 4:35pm Re: MSSQL [Re: StuyMac]
AX_125 Offline

Forum Guardian

Registered: 10th Nov 2003
Posts: 3793
Loc: Home
Already tried that frown
_________________________

I am a signature virus, copy me into your signature to help me spread.

Top
#155437 - 11th May 2007 4:39pm Re: MSSQL [Re: StuyMac]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21059
Loc: Wirral
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
_________________________
My Avatar images are all from the Wirral Gallery.Click Me
Wow Wirral History is coming along Great! Wirral History

we get +200 new members a month now smile

Top
#155441 - 11th May 2007 5:03pm Re: MSSQL [Re: Mark]
AX_125 Offline

Forum Guardian

Registered: 10th Nov 2003
Posts: 3793
Loc: Home
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.
_________________________

I am a signature virus, copy me into your signature to help me spread.

Top
#155445 - 11th May 2007 5:31pm Re: MSSQL [Re: AX_125]
MattLFC Offline
Wiki Master

Registered: 14th Aug 2004
Posts: 22315
Loc: Moreton/Beirut/Mobile
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

Top
#155449 - 11th May 2007 5:50pm Re: MSSQL [Re: MattLFC]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21059
Loc: Wirral
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.
_________________________
My Avatar images are all from the Wirral Gallery.Click Me
Wow Wirral History is coming along Great! Wirral History

we get +200 new members a month now smile

Top
#155454 - 11th May 2007 5:58pm Re: MSSQL [Re: Mark]
MattLFC Offline
Wiki Master

Registered: 14th Aug 2004
Posts: 22315
Loc: Moreton/Beirut/Mobile
Lol easy enough mistake to make to be honest.

Top
#156100 - 18th May 2007 10:26am Re: MSSQL [Re: MattLFC]
AX_125 Offline

Forum Guardian

Registered: 10th Nov 2003
Posts: 3793
Loc: Home
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)

_________________________

I am a signature virus, copy me into your signature to help me spread.

Top

Moderator:  Mark 
Random Wirral Images

Click to View Topic.
Newest Topics
VW t4 fixed side window replacement
by Mike72
Today at 08:00 AM
Range Rover P38A Air Suspension Help Needed
by Martin1943
20th Jun 2017 8:06pm
Loving Home Wanted For 3 Cats.
by DavidC
20th Jun 2017 8:32am
Finsbury Park mosque.
by Beethoven
19th Jun 2017 11:42am
Loving Home Wanted For 3 Cats.
by DavidC
18th Jun 2017 6:02pm
For Sale & Free
Washing machine
by GingerTom
20th Jun 2017 9:05pm
22" full 1080p hd and freeview tv
by monsterz4
20th Jun 2017 8:50pm
Apple TV box the 1gen
by monsterz4
20th Jun 2017 8:48pm
42 lf smart tv
by stumpyduck
20th Jun 2017 8:15pm
Wanted roof box
by monsterz4
19th Jun 2017 10:32am
Featured Member
Registered: 30th Apr 2009
Posts: 2324
Newest Members
Fairz87, mikerobbo84, Robbo1960, Gwhiz03, SamphireGreen
12328 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Shotwick - Old And New (Hall and Solar Farm)
by diggingdeeper
15th Jun 2017 10:19pm
Sefton Park
by diggingdeeper
15th Jun 2017 10:02pm
Property Law
by lau2908
14th Jun 2017 8:04pm
van driver needed
by futurepast
14th Jun 2017 7:34pm
Sailing volunteers
by dogsbrain
14th Jun 2017 4:31pm
News : New Topics
Finsbury Park mosque.
by Beethoven
19th Jun 2017 11:42am
Grenfell Tower - Notting Hill
by diggingdeeper
14th Jun 2017 5:13am
Manchester airport
by Dilly
9th Jun 2017 6:01pm
helicopter landing irby park
by fish5133
7th Jun 2017 12:22am
LOST: Car key
by little_pob
31st May 2017 7:37pm
New Enthusiast Forums
VW t4 fixed side window replacement
by Mike72
Today at 08:00 AM
Range Rover P38A Air Suspension Help Needed
by Martin1943
20th Jun 2017 8:06pm
Loving Home Wanted For 3 Cats.
by DavidC
20th Jun 2017 8:32am
Loving Home Wanted For 3 Cats.
by DavidC
18th Jun 2017 6:02pm
Code reader
by madrob
16th Jun 2017 9:09am
(Views 24hrs)Trending Newest Topics
VW t4 fixed side window replacement 18
Wirral Sunrise Sunset
Sunrise Thu 4:43am
Sunset Thu 9:45pm
Local Time Thu 5:25pm
WikiWirral Can . . . .