Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Transaction Log Back Up files Very LargeTransaction Log Back Up files Very Large
Previous
 
Next
New Post
10/12/2011 4:36 PM
 
Stan Kitson

Joined: 7/16/2004
Posts: 184
I don't understand what makes a transaction log backup files so large.

I have a couple DNN sites - both 5.6.3. , SQL Server 2005.

"A:"  has large transaction log and small transaction log backup files:
The transaction log is 653MB, the typical transaction backup is 3 to 4 MB.

"B"  has a Transaction log that is 407 MB with transaction backup file ranging between 350 to 425 MB.

Site log history is the same for each - 15 days - and the site activity is about the same, 10,000 log entries vs 8,500.

Schedule History is larger in B than A, 2,900 record in B, 670 records in A since October 1. That' can't account for a transaction backup that's 100x larger.

What else should I be looknig at?

If I detach the database, delete the transaction log and reattach the database, the new transaction log will be created... do I lose the abiity to restore the database using the transaction log backups created from the deleted log?

Thanks.

 
New Post
10/12/2011 5:22 PM
 
April Spence


devcentral.f5.com
Joined: 11/4/2005
Posts: 562
Here is a good background article on SQL Server transaction logs.

http://itmanagement.earthweb.com/networks/SQL-Server-How-To-Transaction-Log-Maintenance-for-Painless-Data-Recovery-3777461.htm

A good backup, maintenance strategy can keep your logs in check...but depending on how far back you need to store data for recovery you will either be storing bak files or logs.

So I guess the question is what's the worry?

I should mention one of my DNN installations has a 833mb database and a 4.9G log.

Steven Webster
Manager, Community Platform
F5 Networks, DevCentral
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Transaction Log Back Up files Very LargeTransaction Log Back Up files Very Large


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out