Data Backup and Recovery

how to schedule powershell commands for clone a db in smsql 5

visnetapp

Hi

i want to schedule a clone job in smsql 5

in the wizard you have no option to do this

with powershell commands executed in the netapp cli works

when i make a sqljob wiht powershell option d'osnt work

how i can schedule my job in sql or task scheduler

thx for help

andy

1 REPLY 1

visnetapp

here is the solution:

powershell.exe -ImportSystemModules clone-database -Server Servername -Username admin -Password P@ssw0rd -ServerInstance Instance -Database DBName -TargetDatabase DBName_Clone -TargetServerInstance Targetserver -MountPointDir c:\Mountpoint -UseMountPoint

you can schedule this batch by Windows Task Scheduler or in a SQL Job.

I have created a SQL Job with a detach Step first.

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public