If you have a site which sends out emails to the customer, and you want to save a copy of the mail, what is an effective strategy? If you save it to a table in your database (eg create a table called Mail), it gets very large very quickly. Some strategies I've seen are: Save it to the file system Run a scheduled task to clear old ent...
I've been working with a friend trying to come up with a way to backup his important data. He's wanting to put a flash drive or portable drive in a fire safe. I'm thinking the temperature in the safe, while not enough to damage paper, will damage the delicate electronics in a flash drive or warp the platters on a hard drive. I've sugg...
A problem I ran into a while back I never found a good solution for... Say you have a working copy checked out from subversion at revision 7500, and the disk holding the current repository dies. You've got a backup of the repository at, say, revision 7450. It's easy to restore the repository backup, but any attempt to use the working co...
Is it possible to use Subversion (SVN) as general purpose backup tool? (As a kind of rsync alternative.) ...
My company's main file server is backed up to tape (DAT 25GB). We use several tapes for the backup: Daily D1=Monday, D2=Tuesday, D3=Wednesday, D4=Thursday Weekly W1=1st Friday of the month, W2=2nd, W3=3rd Monthly M1=1st month of the year, M2=2nd, M3=3rd The monthly tapes are kept of site. Additionaly backups are made twice a year. We...
Are there any tricks for speeding up mySQL dumps and imports? This would include my.cnf settings, using ramdisks, etc. ...
Using Oracle 10g with our testing server what is the most efficient/easy way to backup and restore a database to a static point, assuming that you always want to go back to the given point once a backup has been created. A sample use case would be the following install and configure all software Modify data to the base testing point t...
Working on a project at the moment and we have to implement soft deletion for the majority of users (user roles). We decided to add an "is_deleted='0'" field on each table in the database and set it to '1' if particular user roles hit a delete button on a specific record. For future maintenance now, each SELECT query will need to ensure...
What is the best way to backup VMWare Servers (1.0.x)? The virtual machines in question are our development environment, and run isololated from the main network (so you can't just copy data from virtual to real servers). The image files are normally in use and locked when the server is running, so it is difficult to back these up with...
Hi, I have a VPS host running 3 sites using Ubuntu Hardy. I've spent much time setting it up. That includes all the installation + configuration and stuff. What ways are there to do backup + restore for VPS? ...
The backup and restore process of a large database or collection of databases on sql server is very important for disaster & recovery purposes. However, I have not found a robust solution that will guarantee the whole process is as efficient as possible, 100% reliable and easily maintainable and configurable accross multiple servers. ...
Is there a program or API I can code against to extract individual files from a Windows Vista Complete PC Backup image? I like the idea of having a complete image to restore from, but hate the idea that I have to make two backups, one for restoring individual files, and one for restoring my computer in the event of a catastrophic failur...
Whenever I try to backup a database it goes until 90% and gets stuck there until I manually kill (because it doesn't stop if I try to stop it) the msftesql process. That clearly means that something makes a conflict between the fulltext indexing and the backup process. So, have you seen anything like this? If not, how would you go abo...
We have a warm sql backup. full backup nightly, txn logs shipped every so often during the day and restored. I need to move the data files to another disk. These DB's are in a "warm backup" state (such that i can't unmark them as read-only - "Error 5063: Database '' is in warm standby. A warm-standby database is read-only. ") and am w...
If our organisation were to switch from a central-server VCS like subversion to a distributed VCS like git, how do I make sure that all my code is safe from hardware failure? With a central-server VCS I just need to backup the repository every day. If we were using a DVCS then there'd be loads of code branches on all the developer machi...
I have to restore a database that has been inadvertently DROPped in MySQL 5.0. From checking the backup files, I only seem to have .FRM files to hold the database data. Can anyone advise whether this is all I need to perform a database restore/import from the backup, or are there other files I should have to hand to complete this? ...
We're looking at CouchdDB for a CMS-ish application. I know the database is implemented as a set of files in the file system, what I'm looking for are common patterns, best practices and workflow advice surrounding backing up our production database, and, especially, the process of cloning the database for use in development and testing...
I've been too lax with performing DB backups on our internal servers. Is there a simple command line program that I can use to backup certain databases in SQL Server 2005? Or is there a simple VBScript? ...
Hi, There are literally thousands of locations where an application is running (.net desktop app),and a requirement is to have the updates to their database (diff from the last upload) to be sent to a central server that will store all the locations data. What options do I have in coming up with a solution? One idea is to generate an X...
Is it possible to use AIX's mksysb and savevg to create a bootable tape with the rootvg and then append all the other VGs? ...