Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My company has a VPS with a webhost that serves a few websites. I would like to set up an automated backup that will cover as much of the system as possible.

Server Info:

  • VPS is running in Microsoft Virtual Server Enterprise Edition
  • Windows Server 2003 Web Edition (32 bit)
  • Microsoft SQL Server 2005 Express

Backup Sources:

  • Individual website web root folders
  • Databases for each site (if needed)
  • IIS settings
  • Other misc. files (not OS or website-related)

Preferably, I would be able to set up a backup scenario for each website that would include the site files and databases for that site and one backup scenario for the server-wide info. However, one global backup would be OK.

The preferred destination for the backups would be an FTP server.

I am currently doing most of this manually (exception of the IIS settings).


locked by HopelessN00b Dec 5 '14 at 8:54

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

What server software is running your VPS? I am asking because VMWare, which is what I am familiar with, has very nice backup/snapshot management console. – user1797 May 12 '09 at 15:28
Added this info to the question - first bullet under Server Info. Thanks! – Raleigh Buckner May 12 '09 at 17:26
up vote 2 down vote accepted

Firstly I would suggest you use rsync to do the replication. rsync looks horrid at first glance, but it's easy to get working and it's very bandwidth efficient. See:

for a quick guide.

You don't say anything about your partition structure. Is it a single C: partition, a small C: with a D: partition for data or something else?

With a small C: plus a bigger D: I would snapshot C: (see to a file on D: then just backup the snapshot. With a single C: partition you can still snapshot C: to a file on C:, but the snapshot will be fairly large as it includes everything on C:.

SQL databases can be dumped to a file using:

osql /S servername /E /Q "backup database fred to disk='D:\fred.bak' with init"

then the .bak files can be backed up.

One last tweak is that in use files can be backed up by using the vshadow.exe applet to make a shadow copy of the C: partition, and replicate the shadow copy to the rsync server. Google for vshadow.exe to find lots of good articles on it, or I will get round to writing an article on it some time soon.


Task scheduler to:

  • Export IIS metabase to file system
  • NTBackup web root folders and IIS metabase file
  • Run sqlcmd to backup databases to disk

Write all of it to an folder you've served up using the FTP server (use a non-standard port and if you can, use an SFTP server). On your end, have a job login to the FTP server and retrieve the files.


Not the answer you're looking for? Browse other questions tagged or ask your own question.