WikiWirral its great, register, enjoy and welcome.
Forum Stats
12452 Members
65 Forums
73748 Topics
996854 Posts
55 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
73 registered (8HBob, 12 invisible), 1210 Guests and 257 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Games for children 950
Fitting bathroom lights need help 304
Travelling Bus and Train Which Tickets? 280
Charity fishing match 268
Replacement Key Fob casing 258
Anyone read this ? 253
Taltalk Broadband Dying 244
Bath Lifts 175
Submarine Disaster 129
Are there any doctors or nurses on here. 127
New General Forums
Brexit bill
by casper
07:33 PM
Telephone Caller Alert - they are NOT BT BROADBAND
by Laraine
17th Nov 2017 6:04pm
Are you a Mathematician ?
by granny
15th Nov 2017 8:59am
Poor Bruce
by diggingdeeper
15th Nov 2017 1:15am
New Wirral History
Downloadable oldwirral pdfs
by derekdwc
9th Oct 2017 12:26pm
Forum Tips
Photo Gallery Forums
clipper yachts arriving for round the world race
Azamara,silouette and balmoral this mornig
Topic Replies
Extending dining table with six chairs
by noodles77
Today at 12:53 AM
Submarine Disaster
by Excoriator
Yesterday at 11:59 PM
Fitting bathroom lights need help
by Salmon
Yesterday at 10:52 PM
What is your Daily Exercise ?
by granny
Yesterday at 10:11 PM
Vaping set
by paul110180
Yesterday at 01:45 PM
Charity fishing match
by paul110180
Yesterday at 01:43 PM
Charity fishing match
by paul110180
Yesterday at 01:32 PM
Games for children
by venice
Yesterday at 01:58 AM
Bongos Bingo Ticket
by venice
Yesterday at 12:36 AM
November
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 ?
The Lanterns at Chester Zoo
by granny
16th Nov 2017 1:05pm
bonfire night
by snowhite
3rd Nov 2017 5:40pm
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
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 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: 21085
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: 21085
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
Submarine Disaster
by diggingdeeper
Yesterday at 05:46 PM
Fitting bathroom lights need help
by yr20405
17th Nov 2017 11:29pm
Charity fishing match
by paul110180
17th Nov 2017 9:29pm
Games for children
by granny
17th Nov 2017 1:35am
Are there any doctors or nurses on here.
by granny
16th Nov 2017 11:52pm
For Sale & Free
Extending dining table with six chairs
by kazaroo
04:46 PM
Water Dispenser Cold Cool Machine Cooler
by markyport
19th Nov 2017 4:45pm
where to get cheap carpet
by mickturner
17th Nov 2017 4:24pm
White radiator single panel 1400 x 600 - good cond
by gerrymoore
16th Nov 2017 9:16am
Samsung Galaxy S7 Titanium Silver + Extras
by j_demo
15th Nov 2017 7:29pm
Featured Member
Registered: 16th Aug 2010
Posts: 838
Newest Members
wagonwheel82, Norfolk, monadrexx, Dipper, DarioLo
12452 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Fitting bathroom lights need help
by yr20405
17th Nov 2017 11:29pm
Games for children
by granny
17th Nov 2017 1:35am
Bath Lifts
by locomotive
16th Nov 2017 6:22pm
The Lanterns at Chester Zoo
by granny
16th Nov 2017 1:05pm
Travelling Bus and Train Which Tickets?
by fish5133
15th Nov 2017 5:31pm
News : New Topics
Submarine Disaster
by diggingdeeper
05:46 PM
Anyone read this ?
by venice
16th Nov 2017 3:22pm
Is this crime against humanity
by granny
13th Nov 2017 4:04pm
Wedding for Cancer Research !
by Katemargaret
11th Nov 2017 10:38pm
The EU and us.
by Excoriator
11th Nov 2017 8:44am
New Enthusiast Forums
Charity fishing match
by paul110180
17th Nov 2017 9:29pm
Are there any doctors or nurses on here.
by granny
16th Nov 2017 11:52pm
Taltalk Broadband Dying
by diggingdeeper
15th Nov 2017 3:40am
Replacement Key Fob casing
by fish5133
14th Nov 2017 7:45pm
Insecure sites.
by venice
13th Nov 2017 3:54pm
(Views 24hrs)Trending Newest Topics
Submarine Disaster 129
Brexit bill 8
Wirral Sunrise Sunset
Sunrise Tue 7:50am
Sunset Tue 4:06pm
Local Time Tue 2:49am
WikiWirral Can . . . .