WikiWirral values you and your opinion.
Forum Statistics
Posts1,028,062
Topics75,592
Members13,512
Forums65
Posts in last 24hrs9
Most Online14,906
Nov 23rd, 2019
Who's Online Now
42 registered members (AX_125, 9 invisible), 1,505 guests, and210 spiders.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


Popular Topics(Views 7days)
New General Forums
George Carlin
by BultacoAstro. 10th Sep 2020 9:00am
Our Earth
by granny. 8th Sep 2020 10:02am
The Moon Landing ?
by BultacoAstro. 29th Aug 2020 4:58pm
Harry McGuire.
by casper. 28th Aug 2020 11:15am
New Wirral History
Stage-Coach Timetables in 1830's
by mikeeb. 19th Sep 2020 4:05pm
Birkenhead Trams 1876
by mikeeb. 17th Sep 2020 3:38pm
WHAT PUB
by derekdwc. 12th Sep 2020 12:51pm
365 Crown Vaults 34 Watson Street
by mikeeb. 1st Sep 2020 5:05pm
94 Clarendon Hotel 109 to 111 Chester Street
by mikeeb. 31st Aug 2020 5:54pm
Forum Tips
Photo Gallery Forums
Boaty McBoatface takes shape
The gathering storm: Mersey waterfront today
Topic Replies
Coronavirus
by granny. 20th Sep 2020 10:54pm
Classic Rock The Bands Are Awakening
by BultacoAstro. 20th Sep 2020 8:24pm
Birkenhead Trams 1876
by locomotive. 20th Sep 2020 8:00pm
Wooden Single Bed, Headboard, Mattress and Drawer
by rhoobarb2002. 20th Sep 2020 1:52pm
Stage-Coach Timetables in 1830's
by mikeeb. 19th Sep 2020 4:05pm
Dorothea Quarry Aug 2020
by mikeeb. 19th Sep 2020 3:41pm
Trinity Street Birkenhead
by MIKE6570. 19th Sep 2020 12:22pm
Award for Corbyn ???
by casper. 19th Sep 2020 9:34am
cat found,Wallasey
by muzzy2. 19th Sep 2020 8:07am
September
M T W T F S S
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 ?
Previous Topic
Next Topic
Print Topic
Rate Topic
MSSQL #155425
11th May 2007 1:12pm
11th May 2007 1:12pm
Joined: Nov 2003
Posts: 3,793
Home
AX_125 Online content OP

Forum Guardian
AX_125  Online Content OP

Forum Guardian
Joined: Nov 2003
Posts: 3,793
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?


[Linked Image]
I am a signature virus, copy me into your signature to help me spread.
Google Ads
Re: MSSQL [Re: AX_125] #155429
11th May 2007 1:59pm
11th May 2007 1:59pm
Joined: Nov 2003
Posts: 12,002
Wirralshire
StuyMac Offline
Wiki Master
StuyMac  Offline
Wiki Master
Joined: Nov 2003
Posts: 12,002
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?
Re: MSSQL [Re: StuyMac] #155436
11th May 2007 3:35pm
11th May 2007 3:35pm
Joined: Nov 2003
Posts: 3,793
Home
AX_125 Online content OP

Forum Guardian
AX_125  Online Content OP

Forum Guardian
Joined: Nov 2003
Posts: 3,793
Home
Already tried that frown


[Linked Image]
I am a signature virus, copy me into your signature to help me spread.
Re: MSSQL [Re: StuyMac] #155437
11th May 2007 3:39pm
11th May 2007 3:39pm
Joined: Nov 2003
Posts: 21,231
Wirral
Mark Online Reading

Wiki Master
Mark  Online Reading

Wiki Master
Joined: Nov 2003
Posts: 21,231
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
Re: MSSQL [Re: Mark] #155441
11th May 2007 4:03pm
11th May 2007 4:03pm
Joined: Nov 2003
Posts: 3,793
Home
AX_125 Online content OP

Forum Guardian
AX_125  Online Content OP

Forum Guardian
Joined: Nov 2003
Posts: 3,793
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.


[Linked Image]
I am a signature virus, copy me into your signature to help me spread.
Re: MSSQL [Re: AX_125] #155445
11th May 2007 4:31pm
11th May 2007 4:31pm
Joined: Aug 2004
Posts: 22,315
Moreton/Beirut/Mobile
MattLFC Offline
Wiki Master
MattLFC  Offline
Wiki Master
Joined: Aug 2004
Posts: 22,315
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

Re: MSSQL [Re: MattLFC] #155449
11th May 2007 4:50pm
11th May 2007 4:50pm
Joined: Nov 2003
Posts: 21,231
Wirral
Mark Online Reading

Wiki Master
Mark  Online Reading

Wiki Master
Joined: Nov 2003
Posts: 21,231
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
Re: MSSQL [Re: Mark] #155454
11th May 2007 4:58pm
11th May 2007 4:58pm
Joined: Aug 2004
Posts: 22,315
Moreton/Beirut/Mobile
MattLFC Offline
Wiki Master
MattLFC  Offline
Wiki Master
Joined: Aug 2004
Posts: 22,315
Moreton/Beirut/Mobile
Lol easy enough mistake to make to be honest.

Re: MSSQL [Re: MattLFC] #156100
18th May 2007 9:26am
18th May 2007 9:26am
Joined: Nov 2003
Posts: 3,793
Home
AX_125 Online content OP

Forum Guardian
AX_125  Online Content OP

Forum Guardian
Joined: Nov 2003
Posts: 3,793
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)



[Linked Image]
I am a signature virus, copy me into your signature to help me spread.

Moderated by  Mark 

Random Wirral Images

Click to View Topic.
Newest Topics
Stage-Coach Timetables in 1830's
by mikeeb. 19th Sep 2020 4:05pm
Dorothea Quarry Aug 2020
by KevinFinity. 18th Sep 2020 9:45pm
cat found,Wallasey
by doggod. 17th Sep 2020 8:55pm
Birkenhead Trams 1876
by mikeeb. 17th Sep 2020 3:38pm
Spring fitting required
by gerrymoore. 17th Sep 2020 9:20am
For Sale & Free
Wanted Bultaco Astro Or Pursang 360 Model 104
by BultacoAstro. 13th Sep 2020 10:39pm
Wooden Single Bed, Headboard, Mattress and Drawer
by rhoobarb2002. 12th Sep 2020 5:07pm
Vauxhall Alloy Wheels - Astra, Corsa, Zafira etc.
by j_demo. 12th Sep 2020 2:44pm
2x2 seater leather sofas recliner
by paul110180. 7th Sep 2020 8:18am
2x2 seater leather sofas recliner
by paul110180. 7th Sep 2020 7:32am
Member Spotlight
rocks
rocks
3/4 of the way there....
Posts: 6,682
Joined: April 2011
Show All Member Profiles 
Newest Members
RyanEvans, mange1827, Stephen_59, AuntieP, Marks1960
13512 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Van carpet fitter
by Gibbo. 17th Sep 2020 9:16am
Tower road. Birkenhead and now Dock road
by keef666. 6th Sep 2020 1:53pm
Enjoy the street theatre!
by Excoriator. 5th Sep 2020 3:50pm
Laminate flooring
by casper. 4th Sep 2020 6:33pm
Self-Employment Income Support Scheme
by mikeeb. 23rd Aug 2020 3:05pm
News : New Topics
Award for Corbyn ???
by granny. 27th Aug 2020 10:41pm
Casper Specials
by granny. 23rd Aug 2020 5:39pm
Worlds oldest man dies aged 116
by mikeeb. 23rd Aug 2020 2:36pm
When Damascus Falls !
by granny. 13th Feb 2020 11:12pm
Coronavirus
by cools. 30th Jan 2020 5:38pm
New Enthusiast Forums
Dorothea Quarry Aug 2020
by KevinFinity. 18th Sep 2020 9:45pm
cat found,Wallasey
by doggod. 17th Sep 2020 8:55pm
Spring fitting required
by gerrymoore. 17th Sep 2020 9:20am
Customer Is Always Right
by BultacoAstro. 3rd Sep 2020 12:19pm
VW Golf TDi Cambelt
by TudorBlue. 1st Sep 2020 10:04am
Popular Topics(Views 24hrs)
Wirral Sunrise Sunset
Sunrise Mon 6:58am
Sunset Mon 7:11pm
Local Time Mon 8:10am
Powered by UBB.threads™ PHP Forum Software 7.6.1.1