Stuart Moore on Automating SQL Server Backups, Restores and verifications with PowerShell
Rob Sewell on his box of Powershell tricks
Automating SQL Server Backups, Restores and verifications with PowerShell
SQL Server makes it simple to automate backups with jobs and maintenance, but doesn't provide a simple method to schedule test restores to prove the backups have worked. Using PowerShell we can write simple scripts that allow us to automate test restores from our SQL backups, and then check that the restored database is valid, consistent and usable. This session will introduce you to the basics of restoring simple databases with PowerShell scripts, and then extending this to cope with more complex situations including data file relocation, point in time restores and running DBCC checks against the restored database
PowerShell Box Of Tricks
The life of a SQL Server DBA is a busy one. A fount of all knowledge, the SQL Server DBA is often interrupted with small questions and routine tasks. This session will show you some functions that you can use to save time spent on this and hopefully inspire SQL DBAs to explore PowerShell further by showing how easy it is to explore SQL Server properties with it.
Stuart started working with SQL Server 7 in 1999, having spent the intervening years working up through the versions as with time spent as both a DBA and a Developer. Now firmly in the DBA camp and busily automating as much as possible.
Rob is a SQL Server DBA currently supporting several hundred databases ranging from SQL 2000 to SQL 2012 and including Ingres and Oracle for a government organisation. Rob has a fabulous beard and loves to use Powershell to make his life easier.