How to bypass Backup-SqlDatabase prompt for password?

Question

I'm writing a powershell script to run some sql backups to a network share. Is there a way to get around the password prompt?

Backup-SqlDatabase -ServerInstance $SQLServer -Database $DatabaseName -BackupFile "\\network-share\MainDB.bak" -Credential (Get-Credential "sa")

Currently this prompts me for a password. I'd like for these to run automatically without any user intervention.

4c74356b41 · Accepted Answer · 2018-12-19 19:37:08Z

6

just create a credential object and pass it in as you normally would:

$cred = [pscredential]::new('administrator',(ConvertTo-SecureString -String '!Q2w3e4r' -AsPlainText -Force))
Backup-SqlDatabase -ServerInstance $SQLServer -Database $DatabaseName -BackupFile "\\network-share\MainDB.bak" -Credential $cred

answered Dec 19, 2018 at 19:37

4c74356b41

71.5k7 gold badges118 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to bypass Backup-SqlDatabase prompt for password?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related