Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server » Powershell Scripts   (RSS)
Monday, November 19, 2007 5:00 PM

Script: Auto-add new SQL DBs for protection

This is a sample script that will automatically add all the newly available SQL DBs in all instances for protection. You can customize this easily to change the protection policy. Save the attached file as a .ps1 file and invoke through the DPM Management
Posted by dpm | 0 Comments
Attachment(s): AddNewSQL.ps1
Tuesday, September 04, 2007 1:33 PM

CLI Script: Copy latest point in time of SQL DB to a folder

This script copies the latest recovery point of the specified SQL databases to the destination folder on a production server. Save this script as a .ps1 file and run it. Usage and examples of scripts can be found by calling them with ‘-?’ or ‘-help’ from
Posted by dpm | 0 Comments
Tuesday, September 04, 2007 1:29 PM

CLI Script: Recover to latest point in time for a SQL DB

This script restores the latest recovery point of the specified SQL databases. Save this script as a .ps1 file and run it. Usage and examples of scripts can be found by calling them with ‘-?’ or ‘-help’ from inside DPM Management Shell. -------------------------------------
Posted by dpm | 0 Comments
 
Page view tracker