Web Software Architecture and Engineering – Life on the Bleeding Edge

Sometimes you need a simple script to backup the full DB to a file.
Some of the uses of the script I found were:

  • To create a nightly job; simply have a hard file backup on a drive
  • To generate a file on demand for restore to other environments (dev/stage/uat)
  • And to be part of some build process

This script automatically appends a timestamp, so each time you have a fresh copy of the DB. Works great for us! See the associated restore script as well.
See: http://blog.tech-cats.com/2007/10/sql-server-script-to-backup-database-to.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: