WikiWirral 13yrs online 24/7 365 days a year.
Forum Stats
12224 Members
65 Forums
72741 Topics
980439 Posts
70 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
76 registered (11kendo, 15 invisible), 1762 Guests and 189 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
TS Indefatigable 468
Patio work 341
vet fees 305
Hezballah 260
Internet Explorer Not Working 258
Sea Shepherd 248
Seeking old pictures of Egerton Street area, Birkenhead 142
TV wall mount wanted. 106
Doris is on her way 83
Am I missing something ? 69
New General Forums
Wirral track renewal
by snowhite
02:42 PM
Ice in the 1800's
by granny
21st Feb 2017 9:47pm
Am I missing something ?
by dizdazdoz
16th Feb 2017 12:46pm
Valentines Day---Help From The Ladies
by fish5133
10th Feb 2017 7:35pm
New Wirral History
Seeking old pictures of Egerton Street area, Birkenhead
by yoller
19th Feb 2017 7:53pm
TS Indefatigable
by granny
18th Feb 2017 3:32pm
RIP : Chris Kay
by granny
31st Aug 2016 9:25am
Children's home on the Overchurch
by xleahx
26th Apr 2011 7:01pm
423 Archers, Wirral Mark Rake, Wirral, Merseyside
by derekdwc
13th Sep 2009 10:50pm
Forum Tips
Photo Gallery Forums
fireworks on the Mersey last night
Hadlow train station
Topic Replies
Doris is on her way
by diggingdeeper
03:05 AM
423 Archers, Wirral Mark Rake, Wirral, Merseyside
by diggingdeeper
03:02 AM
Changes to bin collections
by fish5133
01:21 AM
Internet Explorer Not Working
by fish5133
01:16 AM
Mk6 Golf TDI 1.6
by Cjoshea
11:06 PM
Rescued Animals.
by granny
10:50 PM
irish music entertainer for St Patrick's night
by kazaroo
03:07 PM
Tony Blair
by snowhite
02:20 PM
TV wall mount wanted.
by j_demo
21st Feb 2017 9:32pm
February
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
Recent Posts : What's On ?
Lion Salt Works/Weaver Hall Museum
by venice
19th Feb 2017 12:19pm
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
13th Feb 2017 8:50pm
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
Digital Wirral : Advertising
Click me for more Information......

* * * vipstudios.co.uk - Photographic Studios * * *
Now Advertise with WikiWirral.
WikiWirral stats 35,000 Page Views a Day +500 Search Engines.. 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: 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 Offline


Wiki Master

Registered: 9th Nov 2003
Posts: 21011
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 Offline


Wiki Master

Registered: 9th Nov 2003
Posts: 21011
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
Doris is on her way
by granny
08:43 PM
irish music entertainer for St Patrick's night
by kazaroo
03:07 PM
Internet Explorer Not Working
by fish5133
12:25 AM
vet fees
by eggandchips
20th Feb 2017 12:01am
Seeking old pictures of Egerton Street area, Birkenhead
by yoller
19th Feb 2017 7:53pm
For Sale & Free
Mk6 Golf TDI 1.6
by Cjoshea
11:05 PM
TV wall mount wanted.
by j_demo
21st Feb 2017 7:53pm
Samick Greg Bennett UK50 Ukulele
by j_demo
20th Feb 2017 9:24pm
2x Brit Floyd tickets 3rd March City entrance
by ambersmum
20th Feb 2017 6:35pm
Sherwood 2x30W amp with phono - £35; other hifi
by montyz
20th Feb 2017 4:09pm
Featured Member
Registered: 7th Dec 2008
Posts: 5349
Newest Members
raybb, CliveK, vonny, Vkj530, SunsetP
12224 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Lion Salt Works/Weaver Hall Museum
by paxvobiscum
18th Feb 2017 9:19pm
Patio work
by steamfan
18th Feb 2017 3:45pm
Ceiling needs smoothing
by yr20405
15th Feb 2017 1:52am
Info? Bill Dobson, Photographer, Martins Bank
by diggingdeeper
13th Feb 2017 12:10pm
War Museum
by missmahjong
12th Feb 2017 1:24pm
News : New Topics
Doris is on her way
by granny
08:43 PM
Hezballah
by venice
17th Feb 2017 11:15am
On-street parking charges dropped
by oldpm01
15th Feb 2017 9:10am
Thousands raised for children of cancer couple.
by fish5133
13th Feb 2017 3:01pm
Lost ladies Swarovski watch
by spider
13th Feb 2017 10:36am
New Enthusiast Forums
irish music entertainer for St Patrick's night
by kazaroo
03:07 PM
Internet Explorer Not Working
by fish5133
12:25 AM
vet fees
by eggandchips
20th Feb 2017 12:01am
Sea Shepherd
by venice
16th Feb 2017 1:06pm
Sounds of the Sixties
by paxvobiscum
11th Feb 2017 8:53pm
(Views 24hrs)Trending Newest Topics
Doris is on her way 83
irish music entertainer for St Patrick's night 47
Wirral track renewal 16
Wirral Sunrise Sunset
Sunrise Thu 7:11am
Sunset Thu 5:39pm
Local Time Thu 7:07am
WikiWirral Can . . . .