dbatools is Growing Up

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737762

  More actions

  March 28, 2018 at 8:52 pm

  #410374

  Comments posted to this topic are about the item dbatools is Growing Up

• xsevensinzx

  One Orange Chip

  Points: 25560

  More actions

  March 28, 2018 at 8:55 pm

  #1984905

  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...

• Jeff Mlakar

  SSCrazy

  Points: 2879

  More actions

  March 29, 2018 at 11:20 am

  #1985014

  +1 for dbatools. I was amazed when I first came across it and tried some commands.

• sugnu iu

  SSCommitted

  Points: 1594

  More actions

  July 20, 2018 at 8:55 am

  #1998423

  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?