Welcome to WikiWirral, sharing is what we do best.
Forum Stats
12182 Members
65 Forums
72596 Topics
978284 Posts
117 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
88 registered (assassin, 18 invisible), 1627 Guests and 195 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Secretive mega shake-up of NHS could cost 15 mil 436
Need help 379
Wirral High Tides? 360
Found a mobile phone 14/01/2017 WALLASEY 347
Sometimes You Could Strangle Someone 337
Asbestos shed removal 324
Paypal help 322
Best Price for Scarpping my car 269
RAC ,AA v Breakdown Recovery 260
Lost Mobile Phone 256
New General Forums
The Scouse Accent
by palemoon
Yesterday at 07:49 PM
birthday wishes
by sunnyside
Yesterday at 12:48 PM
The Green Eyed Girl
by granny
17th Jan 2017 10:33pm
Breastfeeding Dads Want to Be A Breastfeeding Hero
by fish5133
16th Jan 2017 1:24pm
New Wirral History
753 Sea Horse, Unit 9, Wallasey Waterfront
by Norton
Yesterday at 09:07 PM
What was County Hall, Abbey Street, Birkenhead?
by yoller
15th Jan 2017 1:28pm
752 The Old Manor Club, Withens Lane, Liscard
by Norton
13th Jan 2017 2:20pm
751 Plough Inn, Mount Pleasant Rd, New Brighton
by Norton
13th Jan 2017 1:38pm
351 Prince Alfred 30 Tunnel Road 30 30 to 32
by yoller
8th Jan 2017 7:18pm
Forum Tips
Photo Gallery Forums
fireworks on the Mersey last night
Hadlow train station
Topic Replies
New Car tax Rates For New Cars
by diggingdeeper
35 minutes 37 seconds ago
When we live to be a 100 yrs old
by venice
Today at 12:03 AM
Musicals
by snowshoes
Yesterday at 11:47 PM
The Green Eyed Girl
by granny
Yesterday at 10:02 PM
Wanted freezer kit
by dodie
Yesterday at 09:58 PM
2pioneer speakers Free
by dodie
Yesterday at 09:54 PM
Secretive mega shake-up of NHS could cost 15 mil
by venice
Yesterday at 09:48 PM
753 Sea Horse, Unit 9, Wallasey Waterfront
by Norton
Yesterday at 09:07 PM
Taylors Villas 1874 any info?
by locomotive
Yesterday at 09:00 PM
January
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 ?
Indian/Jazz fusion music Liverpool
by buddy
17th Jan 2017 9:46am
Chinese New Year Liverpool
by paxvobiscum
15th Jan 2017 11:08am
Topic Options
Rate This Topic
#155425 - 11th May 2007 2:12pm MSSQL
AX_125 Online   content

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......

* * * Julie : LED Lights Supplied and Fitted Free * * *
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 Online   content

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: 21001
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 Online   content

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: 21001
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 Online   content

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
New Car tax Rates For New Cars
by fish5133
Today at 01:42 AM
753 Sea Horse, Unit 9, Wallasey Waterfront
by Norton
Yesterday at 09:07 PM
Car Value Sites Parkers Auto Trader
by fish5133
Yesterday at 06:05 PM
Spectacles found.
by Beethoven
Yesterday at 01:02 PM
The Green Eyed Girl
by granny
17th Jan 2017 10:33pm
For Sale & Free
Wanted freezer kit
by dodie
Yesterday at 09:58 PM
2pioneer speakers Free
by dodie
Yesterday at 09:54 PM
Looking to swap an xbox one for a ps4
by surykata
Yesterday at 08:10 PM
Wanted old cars spares or repairs
by vw_kyle
17th Jan 2017 1:08pm
Astra 1.9 diesel 06
by lansyp
16th Jan 2017 8:47pm
Featured Member
Registered: 13th Apr 2009
Posts: 67
Newest Members
Collette63, shellylou, sgjrob, pjmeaneydog, jennynoonan
12182 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Paypal help
by venice
17th Jan 2017 8:59pm
Brown Bin Collections Restarting Today 17th Jan
by fish5133
17th Jan 2017 9:04am
Indian/Jazz fusion music Liverpool
by paxvobiscum
15th Jan 2017 11:19am
Chinese New Year Liverpool
by paxvobiscum
15th Jan 2017 11:08am
Asbestos shed removal
by TRFCKrisTRFC
13th Jan 2017 10:51pm
News : New Topics
Spectacles found.
by Beethoven
Yesterday at 01:02 PM
When we live to be a 100 yrs old
by granny
Yesterday at 11:46 AM
Secretive mega shake-up of NHS could cost 15 mil
by RUDEBOX
16th Jan 2017 5:58pm
Lost Mobile Phone
by spinner1
15th Jan 2017 6:56pm
Found a mobile phone 14/01/2017 WALLASEY
by GaryFromWirral
15th Jan 2017 11:28am
New Enthusiast Forums
New Car tax Rates For New Cars
by fish5133
Today at 01:42 AM
Car Value Sites Parkers Auto Trader
by fish5133
Yesterday at 06:05 PM
A Little Girl Gets A Kitten
by Uffda
17th Jan 2017 3:45pm
Best Price for Scarpping my car
by Mike72
17th Jan 2017 1:02pm
Diagnosis Route
by fish5133
17th Jan 2017 12:10am
(Views 24hrs)Trending Newest Topics
When we live to be a 100 yrs old 256
Car Value Sites Parkers Auto Trader 104
753 Sea Horse, Unit 9, Wallasey Waterfront 41
Spectacles found. 40
Wanted freezer kit 37
Looking to swap an xbox one for a ps4 35
The Scouse Accent 30
New Car tax Rates For New Cars 27
birthday wishes 15
Wirral Sunrise Sunset
Sunrise Thu 8:14am
Sunset Thu 4:31pm
Local Time Thu 5:15am
WikiWirral Can . . . .
Advertising Click me
To Advertise with
Wikiwirral Click Me