March 28, 2018 at 8:52 pm
Comments posted to this topic are about the item dbatools is Growing Up
March 28, 2018 at 8:55 pm
Looks pretty sweet. Reading this makes me want to do something similar for Azure Data Warehouse, but with a Python command-line tool instead. Hrrm...
March 29, 2018 at 11:20 am
+1 for dbatools. I was amazed when I first came across it and tried some commands.
July 20, 2018 at 8:55 am
hello guys hope you are all well. if try to schedule through the SQL Agent the following powershell
SL 'D:\DBA'
.\refreshDatabase.ps1
where the refreshDatabase.ps1 is actually executing one of the dbatools scripts....
****************************************************************
Import-Module D:\DBA\dbatools-master\dbatools.psd1
Copy-DbaDatabase -Source "SERVER_ONE" -Destination "SERVER_TWO" -Database DBNAME -WithReplace -BackupRestore -NetworkShare "\\SHARE\DBA"
****************************************************************
the job works, the database is restored but the actual SQL JOB run indefinitely. i need to basically stop it manually. do somebody know why?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply