SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 transaction logs are huge!!!
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 12/15/2006 :  12:38:31  Show Profile  Reply with Quote
quote:
Originally posted by rnbguy

we basically decided to do this process every morning:

Set database recovery model to Simple
shrink log files
Set model to full
do full backup



this is not a good solution. You lose the continuity of your tlogs, so point in time recovery becomes a PITA.



-ec

Edited by - eyechart on 12/15/2006 12:39:42
Go to Top of Page

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 12/17/2006 :  19:04:48  Show Profile  Reply with Quote
okay we found the problem, now where doing full back ups and transaction logs with no shrinks or truncating...

the problem is t-logs where growing huge during indexing and other maintenance plans, these are now being investigated to help reduce size of logs...
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35953 Posts

Posted - 12/18/2006 :  02:17:14  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:

the problem is t-logs where growing huge during indexing and other maintenance plans, these are now being investigated to help reduce size of logs...



http://weblogs.sqlteam.com/tarad/archive/2006/04/11/9585.aspx

Make sure to check out the MS article mentioned in my blog.



Tara Kizer
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 12/18/2006 :  04:17:35  Show Profile  Reply with Quote
"growing huge during indexing"

Look into Index Defrag instead of Reindex.

If you have chosen t he default in the maintenance plan your 100% fill indexes will have been changed to 90% fill - which will be a bit pointless, for example, for a PK using an IDENTITY

Kristen
Go to Top of Page

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 12/18/2006 :  17:44:34  Show Profile  Reply with Quote
thanx guy will look into it, helps alot
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000