Automate SnapManager clone-backup commands

(as much as possible)

I wanted to start using Task Scheduler to run clone-backup commands in the middle of the night.   When I tried to execute a Powershell script, there were errors about restricted execution policies.   Since the clone-backup command is so small, you can just use the -command flag instead.

powershell.exe -psconsolefile “C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlShell.psc1”  -command “clone-backup -Server PROD -Database Admin -RestoreLastBackup 0 -TransLogsToApply 0 -TargetServerInstance DEV”

Schedule this in Task Scheduler

Image

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s