September 24, 2009 at 11:31 am
Greetings,
I am new to NetApp and would like to ask your assistance in scripting a SQL job to clone a database on a SQL server. The idea is to have a few databases cloned regularly so the clone databases are used as sources for cube processing.
The following command line successfully clones ReportServerTempDB database when used manually within NetApp for Powershell app:
clone-database -Server
However, when the same line is used as a Powershell or cmdexec step of a SQL job, the step executes but fails to clone the database. I need assistance in proper syntax. But what we ultimately look for is automating cloning using NetApp, whether with SQL job help or not.
Your assistance is much appreciated.
September 24, 2009 at 12:13 pm
Likely it's a Powershell add-in issue. I'll see if I can get some visibility to this.
September 24, 2009 at 12:35 pm
Thanks a lot Steve, really appreciate your assistance
September 25, 2009 at 10:09 am
Was able to figure it out. Below is the command line to use for Powershell 1.0:
c:\windows\system32\WindowsPowerShell\v1.0\powershell.exe -psconsolefile "c:\program filesetapp\snapmanager for sql server\SmsqlShell.psc1" -command "clone-database" -Server "YourServer" -Database "YourSourceDatabase" -TargetDatabase "YourTargetDatabase"
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply