I need to create a backup of a SQL Server 2005 Database that's only the structure...no records, just the schema. Is there any way to do this?
EDIT: I'm trying to create a backup file to use with old processes, so a script wouldn't work for my purposes, sorry...
When restoring a SQL Server Database, I notice that there are 3 different Recovery States to choose from:
Restore with Recovery
Restore with No Recovery
Restore with Standby
I've always left it at it's default value, but what do they all mean?
(Preferably in layman's terms)
...
In Mysql Administrator, when doing backups, what exactly is "Compatibility Mode"?
I'm trying to bridge backups generated by webmin with the upload tool available inside mysql administrator. My data already has a couple of inconsistencies (ticks, commas, etc, I think) I just wont try to kink out (they might just reappear in the future a...
I was recently tasked with coming up with an offsite backup strategy. We have about 2TB of data that would need to be backed up so our needs are a little out of the norm.
I looked into Iron Mountain and they wanted $12,000 a month!
Does anyone have any suggestions on how best to handle backing up this much data on a budget (like a te...
We have a four Linux boxes (all running Debian or Ubuntu) on our office network. None of these boxes are especially critical and they're all using RAID. To date, I've therefore been doing backups of the boxes by having a cron job upload tarballs containing the contents of /etc, MySQL dumps and other such changing, non-packaged data to ...
How do you restore a database backup using SQL Server 2005 over the network? I recall doing this before but there was something odd about the way you had to do it.
...
I have configured a server with Centos 5.2, and am now working out a backup strategy. I plan on using Amanda as the backup application. Additionally, I am leaning towards using some USB hard drives for backup storage. I will be swapping out one of the Hard Drives each week for an offsite back-up. Does anyone know whether it is possibl...
I'm trying to do a file system backup of a RedHat Enterprise Linux v4 server using Symantec Backup Exec 11d (Rev 7170). The backup server is Windows Server 2003.
I can browse the target server to create a selection list, and when I do a test run it completes successfully.
However, when I run a real backup, the job fails immediately du...
How do you back up your development machine so that in the event of a catastrophic hardware malfunction, you are up and running in the least amount of time possible?
...
What is the best solution for maintaining backup and revision control on live websites?
As part of my job I work with several live websites. We need an efficient means of maintaining backups of the live folders over time. Additionally, updating these sites can be a pain, especially if a change happens to break in the live environment ...
I want to setup a cron job to rsync a remote system to a backup partition, something like:
bash -c 'rsync -avz --delete --exclude=proc --exclude=sys root@remote1:/ /mnt/remote1/'
I would like to be able to "set it and forget it" but what if /mnt/remote1 becomes unmounted? (After a reboot or something) I'd like to error out if /mnt/rem...
I'm looking for Windows backup software that will copy specific workstation folders to a server.
I would like it to be centrally administered instead of administered from the workstation.
It needs to be able to handle open files - especially Outlook pst.
And I would like the server to store the backups in a mirror + reverse incrementa...
I'm new to svn and I'd like to know what are common methods of backing up repositories in a windows environment?
...
How do I make diff ignore temporary files like foo.c~? Is there a configuration file that will make ignoring temporaries the default?
More generally: what's the best way to generate a "clean" patch off a tarball? I do this rarely enough (submitting a bug fix to an OSS project by email) that I always struggle with it...
EDIT: OK, the sh...
I've been using Window Home Server for my backups here at home for most of a year now, and I'm really pleased with it. It's far better than the software I was using previously (Acronis). I'm thinking about a backup strategy for my work machine and I'd like to know how WHS compares with Vista's built-in backup and restore features. The...
After stumbling into Amazon Web Services again I have finally checked their prices and am shocked. Positively. With their flexible billing and extremely low prices, is there any reason for still using a dedicated hosting for a website? The only one I can think of is keeping sensitive data confined to the intranet - but for publicly acces...
I'm a big fan of regular, automatic backups. However, most of my experience is at a personal level. I've recently joined an organization (a university department) where almost nobody seems to have a backup strategy in place. I'd like to promote good backup practices, but aside from telling them what I do at a personal level, I don't q...
Probably like most people here I get the awesome task of looking after all my elderly relatives PCs, because 'you know about computers'. Right now I'm reinstalling XP on two of them, instead of doing useful work, because they are so infected with viruses and malware from general internet surfing ("you're our thousandth customer, click he...
How do I do backups in MySQL?
I'm hoping there'll be something better than just running mysqldump every "x" hours.
Is there anything like SQL Server has, where you can take a full backup each day, and then incrementals every hour, so if your DB dies you can restore up to the latest backup?
Something like the DB log, where as long as...
I have written a log shipping program a number of times. It is a simple program that is used to maintain a warm fail over box for SQL Server.
It has two pieces. On the live dB server it:
Does full and transaction backups and removes old files
On the backup server it:
Copies the backups from the live box
Restores the backups or t...