Skip to content
data.samgreene.com

data.samgreene.com

Search
  • About
  • Monitoring And Automation

Monthly Archives: February 2007

sql 2005 backup restore copy

Copying a database from production to development – a refresh

February 23, 2007 Sam Leave a comment
Todays challenge was to move a production database down to development nightly. It needed to happen after 4pm each weekday. Easy right?

This was all to be done in sql 2005, but the same ideas could be applied to 2000.

My plan was to create a backup at 4pm, copy it to the … Continue Reading ››

Categories

  • 2008
  • Active Directory
  • Admin
  • Backups
  • Badass Tools
  • Cluster
  • Education
  • Interviews
  • Monitoring
  • Party
  • Powershell
  • Razzamataz
  • Restores
  • Roles
  • Schema
  • Scripts
  • Security
  • Speaking
  • sql 2005 backup restore copy
  • SSAS
  • SSIS
  • SSRS
  • Text
  • Troubleshooting
  • TSQL
  • Uncategorized
  • Upgrading
  • VirtualBox

Recent Posts

  • If you work on a computer, get these tools
  • Tweaked script to find all db_owner members
  • Running a plethora of T-SQL
  • Easy Security Fixes
  • Validate Views

Recent Comments

  • Sam on About

Archives

  • March 2017
  • July 2015
  • March 2015
  • February 2015
  • December 2012
  • November 2012
  • October 2012
  • April 2012
  • March 2012
  • December 2011
  • November 2011
  • August 2011
  • April 2011
  • December 2010
  • October 2010
  • September 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • December 2009
  • November 2009
  • October 2009
  • March 2007
  • February 2007

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress