[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MyLittleBackup only some tables

Posted on 2010-01-07
4
Medium Priority
?
294 Views
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?

Cheers
Kevin
0
Comment
Question by:Tech4biz
  • 2
4 Comments
 
LVL 22

Expert Comment

by:neeraj523
ID: 26199448
Hello

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

Author Comment

by:Tech4biz
ID: 26199518
neeraj

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

Kevin
0
 
LVL 2

Assisted Solution

by:autosblindo
autosblindo earned 1000 total points
ID: 26199658
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: http://forum.mylittlebackup.com/yafnet/
0
 

Accepted Solution

by:
Tech4biz earned 0 total points
ID: 26208551
autosblindo

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
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

830 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