tags:

views:

9

answers:

0
Q: 

Any tips for T-SQL/Powershell code to automate failover for log shipping?

Given that I have to use log shipping and have a lot of databases that need to be failed over does anyone have any T-SQL/Powershell code for MS SQL Server 2005 that can automate that failover process as much as possible?

These are the steps it would need to cover (or as many as possible):

  1. Attempt to backup the transaction log one last time if the source database is still available.
  2. Copy all transaction log backups that haven't been copied from the source to the target server.
  3. Restore all transaction log backups except the last backup using NO RECOVERY option.
  4. Restore the last transaction log backup using WITH RECOVERY option.

related questions

How do I access the non-IPM_SUBTREE Public Folder Tree with WMI?
How do I create a custom type in PowerShell for my scripts to use?
iTunes warning message on quit due to scripting
Creating batch jobs in PowerShell
Troubleshooting a NullReference exception in a service
Windows Powershell book - any good experiences?
Windows 2003 Scheduled Task Cmdlet (v 1.0)
How to get started with PowerShell?
get file version in powershell
Set up PowerShell Script for Automatic Execution
Accessing .NET components from Powershell
PowerShell - How do I pass string parameters correctly?
execute shortcuts like programs in powershell
How do I compare two arrays of DataRow objects in PowerShell?
PowerShell App.Config
PowerShell - how do I do a string replacement in a function?
PowerShell FINDSTR eqivalent?
How do I make Powershell run a batch file and then stay open?
quoting System.DirectoryServices.ResultPropertyCollection
Powershell's Invoke-Expression missing param
How do you impersonate an Active Directory user in Powershell?
Why don't my powershell scripts run?
Can I copy files to a Network Place from a script or the command line?
How do you use PowerShell?
What are your favorite Powershell Cmdlets?