Backing up database in powershell

(0) Share

Report

Posted on by Community Member

I am trying to backup database in powershell. I am currently trying to update my version of Business Central (19.0) to the newest (20.0). I am following the documentation and when I try to back up database I keep getting this error:

PS C:\Users\Administrator> Backup-SqlDatabase -ServerInstance BC190 -Database "Demo Database BC (19-0)" -BackupFile "C:\DBbackup\LVNLite.bak"
Backup-SqlDatabase : Failed to connect to server BC190.
At line:1 char:1
  Backup-SqlDatabase -ServerInstance BC190 -Database "Demo Database BC  ...
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      CategoryInfo          : NotSpecified: (:) [Backup-SqlDatabase], ConnectionFailureException
      FullyQualifiedErrorId : Microsoft.SqlServer.Management.Common.ConnectionFailureException,Microsoft.SqlServer.Management.PowerShell
   .BackupSqlDatabaseCommand

I have seen that some people have had trouble with the server instance. I am not sure what I am doing wrong here. Can anyone help?

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 85,764 Super User 2025 Season 1 on at

Like (0)

Report

RE: Backing up database in powershell

Hi, the instance here is not BC instance, this is SQL Server Instance.

https://docs.microsoft.com/en-us/powershell/module/sqlserver/backup-sqldatabase?view=sqlserver-ps

For example:

Hope this will help.

Thanks.

ZHU