I want to backup a AIX 4.3.2.0 machine to a network location. In the past, I've used dd/netcat to backup a system like linux. The server does not appear to NFS or netcat on it. I see that I should this command mksysb to complete backup rootvg -- but I don't have a tape for the tape drive. What are my options here? ...
Hello, Recently I backuped up all of my database parts: mydb mydb_part_1 mydb_part_2 mydb_part_3 Each backup at different speeds. The smallest mydb backedup faster. Then in an absent minded moment, restored just mydb. The system seems to be working but what have I done and what is the best way to handle these roll-over databases? ...
I'm currently backing up my current setup to move over to some new hardware and was wondering what other developers think of first when given a fresh OS installation. Please answer one item per answer so they can be voted on independently. ...
Hey all, I did notice this post but am looking for more specifics. I have 2 servers running Windows 2008 Server Web Edition and am running websites on both of them. I would like to be able to mirror IIS settings onto each box from the other so that, in event of a 'server 1' crash, I can log into 'server 2' and quickly get all sites th...
Hello, I use rsync to back up the files on my server, and mysqldump to back up my database. Here's my concern: A mysqldump on my database takes about 30 seconds. I have a table called photos that stores info about the images a user has uploaded, including the path to the file. I am worried about what will happen when photos are uplo...
Hi, I have a MySQL Database of about 1.7GB. I usually back it up using mysqldump and this takes about 2 minutes. However, I would like to know the answers to the following questions: 1) Does mysqldump block read and/or write operations to the database? Because in a live scenario, I would not want to block users from using the database ...
Regardless of how I got here, I'm in the position of restoring a SVN repository from backup. Unfortunately the backup was slightly corrupted and out of over 19000 revisions, approximately 80 are lost. The backup was a bzip2 file and I was able to use bzip2recover to recover about 99% of the blocks. These are 'known good' since they decom...
Hi my database has started to go over 2GB in backed up size, so I'm looking at options for splitting the file and then reassembling it to restore the database. I've got a series of files from doing the following backup shell file: DATE_STRING=\date +%u%a\ BACKUP_DIR=/home/myhome/backups /usr/local/mysql_versions/mysql-5.0.27/bin/mys...
For my backup plan for SQL Server 2005, I want to do a full on Sunday: BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_full.bak' WITH FORMAT GO Then I want to do a differential nightly the rest of the week: BACKUP DATABASE myDatabase TO DISK = 'D:\Database Backups\myDatabase_Diff.bak' WITH DIFFERENTIAL GO My a...
I used to use svn, and I had AnkhSVN setup in visual studio. I ended up migrating the svn server from a linux box to a windows box about 4 years ago. I didn't have a good backup / restore process on that machine, and I'm afraid I lost most of the histories of stuff I've worked on at home when that hard drive died (I know... I know... I...
I have a table ( A ) in a database that doesn't have PK's it has about 300 k records. I have a subset copy ( B ) of that table in other database, this has only 50k and contains a backup for a given time range ( july data ). I want to copy from the table B the missing records into table A without duplicating existing records of course...
I'm from a linux background, and need to run an incremental backup script on windows. I already have a batch script which dumps my database into a file. What I'd like is to only keep backups for the last seven days in addition to one backup file per week for the last 4 weeks (for example). I presume it's possible to do something like thi...
Hi, I'm writing some sort of backup tool that has to copy all the files in a directory. Now I'm using C#'s File.Copy(String, String, Boolean) method. But another application (which I can't change) simultaneously writes to the files in that directory. So now I wonder if it is possible that a file gets changed halfway the copying process...
I have everyday schedule to backup my database in sqlserver 2005. Now it's looks like this: BACKUP DATABASE [db1] TO DISK = N'D:\SqlServer\Backup\db1.bak' WITH NOINIT , NOUNLOAD , NAME = N'db1backup', NOSKIP , STATS = 10, NOFORMAT But in this case, it's will grow infinitely and I want to store only last 7 backups in file. How c...
I was wondering how you can recover data from your logfile. I'm using sql 2005 (full backup). The problem is that a service cleared my data last night (which it shouldn't have). and now I want to recover those rows that were deleted before. can anyone tell me how I can do this? ...
Ok we have critical transactional database and its in full recovery mode in SQL Server 2008. We have have two different servers in two different data centers on two different timezones. And I am trying to setup best way to make database as upto date as possible using various options. Database is currently only 1.5GB, expected to grow 1GB...
What's the fastest and most efficient way of porting over an IIS setup on one machine to a blank IIS 7 install on another? Including all the sites, applications, virtual directorys, ftp accounts, etc? Thanks. ...
So SQL Server 2008 in Hyper-V is a supported configuration, and should perform well as long as you use fixed or pass-through disks and increase your processor/memory settings appropriately. My question is can I use snapshots as a reliable backup mechanism, or should I use the tried and trusted maintenance plan to do my backups? ...
Right now I am using Windows XP. If i just copy the whole repository folder in visual SVN, once the server is down, how can i restore it via the backuped repository folder? another better solution to backup and restore in visual svn ? by the way, any method for backup and restore in visual source control? ...
Is it possible copy the physical Transaction log file for SQL 2005? Currently our databases are backed up every night with hourly Transaction logs taken during the day. Is it possible that after the hourly backup has been done that the physical log file can be copied to another server? what steps would need to be taken to get this to...