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:
Post a Comment