WikiWirral Wirral's Biggest Online Forum
Forum Stats
12137 Members
65 Forums
72391 Topics
976099 Posts
36 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
78 registered (11kendo, 11 invisible), 1572 Guests and 217 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Wirral Globe 601
HMT Lancastria 442
Another Big Waste Fire in Liverpool. 405
Name help 389
Vet help 310
Vet help 300
Another tree down on Arrowe park Road? 200
54 plate renault clio 3rd brake light 200
That was kept a bit quiet? 154
Mobile mechanic needed to fit a wishbone 137
New General Forums
Lib/dems rule the day
by JimmyG
2nd Dec 2016 10:59pm
Daft funny joke
by venice
2nd Dec 2016 5:54pm
We dont learn much.
by venice
1st Dec 2016 9:22pm
Freegle
by venice
1st Dec 2016 6:36pm
New Wirral History
Name help
by Paternoster21
3rd Dec 2016 8:03am
HMT Lancastria
by granny
2nd Dec 2016 11:38pm
Cubitts Holland and Hannen
by fish5133
27th Nov 2016 5:38pm
Fire station
by chris7777
22nd Nov 2016 12:24pm
Buy a house in Greasby for 12s a week - in 1935
by yoller
6th Oct 2016 6:56pm
Forum Tips
Photo Gallery Forums
fireworks on the Mersey last night
Hadlow train station
Topic Replies
Vet help
by diggingdeeper
10:50 PM
RIP Peter Vaughan
by Mark
10:00 PM
Talk Talk Security Breach
by Mark
09:59 PM
Blank Page : Offline
by Mark
09:55 PM
Iphone 5s, Grey, near mint condition, 50
by anniebo28
09:39 PM
Mobile mechanic needed to fit a wishbone
by anniebo28
07:30 PM
That was kept a bit quiet?
by diggingdeeper
06:19 PM
Another tree down on Arrowe park Road?
by fish5133
02:13 PM
MIG welder
by vw_kyle
01:49 PM
December
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 31
Recent Posts : What's On ?
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
30th Nov 2016 9:16pm
World Aids Day Event 2016. Liverpool
by RUDEBOX
30th Nov 2016 9:05pm
Topic Options
Rate This Topic
#155425 - 11th May 2007 2:12pm MSSQL
AX_125 Offline

Forum Guardian

Registered: 10th Nov 2003
Posts: 3791
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
Digital Wirral : Advertising
Click me for more Information......

WikiWirral Numbers : Between 150 and 200 New Members Every Month. With Over 3,500 unique visits and 35,000 Page Views each day. Average +500 Search Engines Daily and over 1,000,000 Million Page views a Month. Advertising from 20 . Click Me
#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: 3791
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: 20962
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: 3791
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: 20962
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: 3791
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
Talk Talk Security Breach
by fish5133
06:19 PM
Mobile mechanic needed to fit a wishbone
by anniebo28
6th Dec 2016 7:13pm
Vet help
by colin86
6th Dec 2016 6:25pm
Another tree down on Arrowe park Road?
by Davefabo
6th Dec 2016 11:08am
Game shocking prices!!!
by eddtheduck
5th Dec 2016 4:55pm
For Sale & Free
Iphone 5s, Grey, near mint condition, 50
by anniebo28
07:40 PM
Roberts Concerto 2 CD Player For Visually Impaired
by Tranquil
6th Dec 2016 10:05pm
Gaming chair
by monsterz4
6th Dec 2016 8:27pm
MIG welder
by anniebo28
6th Dec 2016 1:34am
IPhone 4s 16gb 35
by anniebo28
4th Dec 2016 12:45pm
Featured Member
Registered: 14th Aug 2015
Posts: 72
Newest Members
lucyw, BarbaraL, SherryLover, missyb, DavidSharpe
12137 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Gymnastics coaches needed.
by margy
3rd Dec 2016 9:28pm
Wirral Globe
by locomotive
1st Dec 2016 6:25pm
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
30th Nov 2016 9:16pm
World Aids Day Event 2016. Liverpool
by RUDEBOX
30th Nov 2016 9:05pm
A job. Company not named.
by venice
30th Nov 2016 6:30pm
News : New Topics
RIP Peter Vaughan
by diggingdeeper
04:22 AM
That was kept a bit quiet?
by venice
6th Dec 2016 11:25am
Another tree down on Arrowe park Road?
by Davefabo
6th Dec 2016 11:08am
Bunchems Xmas present warning
by venice
6th Dec 2016 9:28am
Another Big Waste Fire in Liverpool.
by Wally1
4th Dec 2016 10:24am
New Enthusiast Forums
Talk Talk Security Breach
by fish5133
06:19 PM
Mobile mechanic needed to fit a wishbone
by anniebo28
6th Dec 2016 7:13pm
Vet help
by colin86
6th Dec 2016 6:25pm
Game shocking prices!!!
by eddtheduck
5th Dec 2016 4:55pm
54 plate renault clio 3rd brake light
by Mike72
1st Dec 2016 12:52pm
(Views 24hrs)Trending Newest Topics
Vet help 300
Talk Talk Security Breach 104
RIP Peter Vaughan 84
Wirral Sunrise Sunset
Sunrise Thu 8:15am
Sunset Thu 3:53pm
Local Time Thu 12:10am
WikiWirral Can . . . .