Monday, June 30, 2008

SQL Server "Panic" Backup

One of the new features of SQL Server 2008 is it's integration with Powershell, and the ability to script just about any task.

Buck Woody has put together a pretty interesting "Panic Backup" script that will iterate through an XML file containing server and database names and back them all up. You can read about this here: http://blogs.msdn.com/buckwoody/archive/2008/06/30/sql-server-2008-improvements-practicals-powershell-run-a-panic-backup.aspx

No comments: