MyLittleBackup only some tables

Posted on 2010-01-07
Last Modified: 2012-05-08
I have an online database that I need to back up and restore using myLittleBackup. The problem is that I need to exclude one Table from the backup as it is huge.

Is there a way to backup a Database using myLittleBackup and exclude a table from the backup?

Question by:Tech4biz
    LVL 22

    Expert Comment


    I dont think that any backup tool will give you this option..

    Author Comment


    I can think of a couple, but my question is with MyLittleBackup.

    LVL 2

    Assisted Solution

    I don't know MyLittleBackup, so i can't answer you.
    But I can suggest you to use their Community forum and ask them if it's possible and how.
    Community forum link:

    Accepted Solution


    It turns out that you are correct, but I came up with a workaround.

    1) Using myLittleBackup, create a full backup.
    2) Remove the unrequired tables.
    3) Back up the reduced Database.
    4) Restore the full backup to the source Database (thus re-adding the removed tables).
    5) Restore the reduced backup to the new database.

    Thanks for your help

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now