1

I am looking for a PowerShell script which can take backup and restore MS-SQL databases using SQL authentication.

Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
san1ty
  • 11
  • 1

1 Answers1

1

You can use Backup-DbaDatabase cmdlet from dbatools, you just need to install the module first and then set the -SqlCredential parameter with the username and password. Lots of examples out there.

Peter Hahndorf
  • 14,058
  • 3
  • 41
  • 58