NAV 2013 R2: Backup and Restore

Hi Waldo,

Thanks for your reply.

I have found the cause of the problem.
The error was caused due to insufficient rights of the NT AUTHORITY\NETWORK SERVICE login on SQL server

Best regards,
Robert

Hi Waldo .. thanks for the reply … 🙂

Its difficult to test if both sql and NAV services are installed on the same server …
because then the Nav commands are avallible on the sql server and sql commands are avalible for NAV cmdlets
but when you run it remotely the backup-sqldatabase command wont be avallible on th eNAV server (thats why i use the invoke-command) but as you can see in the error … it sends a null value insted of the accually varibles value ….i think it is because that it sends the string to the sql server and executes ít there … but on the sql server the varible dosent exsist .. and is therefor null .. but is there a trick for sending the value insted of the varible … ?

**********

PS C:\Windows\system32>
Set-ExecutionPolicy unrestricted -Force
Import-Module ‘C:\Program Files\Microsoft Dynamics NAV\80\Service_NAV2015_MT\NAV2015_MT\NavAdminTool.ps1’
$ServiceInstance = ‘NAV2015_MT’
$sqlserver = ‘sql-d166′
#Backup the Application Database
$NavApplication = Get-NAVApplication $ServiceInstance
Invoke-Command -ComputerName $sqlserver {Backup-SqlDatabase -ServerInstance $NavApplication.’Database Server’ -Database $NavApplication.’Database Name’ -BackupAction Database}
#Backup All the Tenant Databases
$NavTenants = Get-NAVTenant $ServiceInstance
Foreach ($NavTenant in $NavTenants)

{
Invoke-Command -ComputerName $sqlserver {Backup-SqlDatabase -ServerInstance $NavTenant.DatabaseServer -Database $NavTenant.Databasename -BackupAction Database}
}

******then i get these errors********

Cannot validate argument on parameter ‘ServerInstance’. The argument is null or empty. Provide an argument that is not null or empty, and then try the
command again.
+ CategoryInfo : InvalidData: (:) [Backup-SqlDatabase], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.SqlServer.Management.PowerShell.BackupSqlDatabaseCommand
+ PSComputerName : sql-d166

Cannot validate argument on parameter ‘ServerInstance’. The argument is null or empty. Provide an argument that is not null or empty, and then try the
command again.
+ CategoryInfo : InvalidData: (:) [Backup-SqlDatabase], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.SqlServer.Management.PowerShell.BackupSqlDatabaseCommand
+ PSComputerName : sql-d166

Cannot validate argument on parameter ‘ServerInstance’. The argument is null or empty. Provide an argument that is not null or empty, and then try the
command again.
+ CategoryInfo : InvalidData: (:) [Backup-SqlDatabase], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.SqlServer.Management.PowerShell.BackupSqlDatabaseCommand
+ PSComputerName : sql-d166

************************************

Best regards

Anders