You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
VERBOSE: [16:01:28][Invoke-DbaDbLogShipping] Started log shipping for US00SSQL03 to US00SSQL02
VERBOSE: [16:01:28][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:28][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [16:01:28][Invoke-DbaDbLogShipping] Testing backup network path \US00SSQL03\Backup
VERBOSE: [16:01:28][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:28][Connect-DbaInstance] authentication method is 'local ad'
VERBOSE: [16:01:29][Invoke-DbaDbLogShipping] Setting backup compression to 1.
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Destination database status set to NO RECOVERY
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup retention set to 4320
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup Threshold set to 60
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy retention set to 4320
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] History retention set to 14420
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore alert Threshold set to 45
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore delay set to 0
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore retention set to 4320
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore Threshold set to 45
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Primary monitor server security mode set to 1
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Secondary monitor server security mode set to 1
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup frequency relative interval set to Unused
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup frequency recurrence factor set to 0
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy frequency relative interval set to Unused
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy frequency recurrence factor set to 0
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore frequency relative interval set to Unused
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore frequency recurrence factor set to 0
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup start date set to 20240516
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup start time set to 000000
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup end time set to 235959
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy start date set to 20240516
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy start time set to 000000
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy end time set to 235959
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore start date set to 20240516
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore start time set to 000000
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore end time set to 235959
VERBOSE: [16:01:31][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:31][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [16:01:32][Invoke-DbaDbLogShipping] Testing copy destination path \US00SSQL02\Backup
VERBOSE: [16:01:32][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:32][Connect-DbaInstance] authentication method is 'local ad'
VERBOSE: [16:01:33][Invoke-DbaDbLogShipping] Backup local path set to W:\MSSQL14.MSSQLSERVER\MSSQL\Backup\AirWatch_DB10.
VERBOSE: [16:01:33][Invoke-DbaDbLogShipping] Backup network path set to \US00SSQL03\Backup\AirWatch_DB10.
VERBOSE: [16:01:33][Invoke-DbaDbLogShipping] Testing database backup network path \US00SSQL03\Backup\AirWatch_DB10
VERBOSE: [16:01:33][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:33][Connect-DbaInstance] authentication method is 'local ad'
VERBOSE: [16:01:34][Invoke-DbaDbLogShipping] Database backup network path \US00SSQL03\Backup\AirWatch_DB10 not found. Trying to create it..
VERBOSE: [16:01:34][Invoke-Command2] Creating backup folder \US00SSQL03\Backup\AirWatch_DB10
WARNING: [16:01:34][Invoke-DbaDbLogShipping] Something went wrong creating the backup directory | The FileSystem provider supports credentials only on the New-PSDrive cmdlet. Perform the operation again without specifying credentials.
VERBOSE: [16:01:34][Invoke-DbaDbLogShipping] Finished setting up log shipping.
Microsoft SQL Server 2019 (RTM-CU25) (KB5033688) - 15.0.4355.3 (X64) Jan 30 2024 17:02:22 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2019 Datacenter 10.0 (Build 17763: ) (Hypervisor)
.NET Framework Version
.NET Framework 4.8.4645.0
The text was updated successfully, but these errors were encountered:
xshen1
changed the title
Issue with creating new directory when enabling logshipping.
Issue with creating new directory when Invoke-DbaDbLogShipping.
May 16, 2024
Verified issue does not already exist?
I have searched and found no existing issue
What error did you receive?
VERBOSE: [16:01:28][Invoke-DbaDbLogShipping] Started log shipping for US00SSQL03 to US00SSQL02
VERBOSE: [16:01:28][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:28][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [16:01:28][Invoke-DbaDbLogShipping] Testing backup network path \US00SSQL03\Backup
VERBOSE: [16:01:28][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:28][Connect-DbaInstance] authentication method is 'local ad'
VERBOSE: [16:01:29][Invoke-DbaDbLogShipping] Setting backup compression to 1.
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Destination database status set to NO RECOVERY
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup retention set to 4320
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup Threshold set to 60
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy retention set to 4320
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] History retention set to 14420
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore alert Threshold set to 45
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore delay set to 0
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore retention set to 4320
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore Threshold set to 45
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Primary monitor server security mode set to 1
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Secondary monitor server security mode set to 1
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup frequency relative interval set to Unused
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup frequency recurrence factor set to 0
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy frequency relative interval set to Unused
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy frequency recurrence factor set to 0
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore frequency relative interval set to Unused
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore frequency recurrence factor set to 0
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup start date set to 20240516
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup start time set to 000000
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Backup end time set to 235959
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy start date set to 20240516
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy start time set to 000000
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Copy end time set to 235959
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore start date set to 20240516
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore start time set to 000000
VERBOSE: [16:01:31][Invoke-DbaDbLogShipping] Restore end time set to 235959
VERBOSE: [16:01:31][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:31][Connect-DbaInstance] authentication method is 'local integrated'
VERBOSE: [16:01:32][Invoke-DbaDbLogShipping] Testing copy destination path \US00SSQL02\Backup
VERBOSE: [16:01:32][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:32][Connect-DbaInstance] authentication method is 'local ad'
VERBOSE: [16:01:33][Invoke-DbaDbLogShipping] Backup local path set to W:\MSSQL14.MSSQLSERVER\MSSQL\Backup\AirWatch_DB10.
VERBOSE: [16:01:33][Invoke-DbaDbLogShipping] Backup network path set to \US00SSQL03\Backup\AirWatch_DB10.
VERBOSE: [16:01:33][Invoke-DbaDbLogShipping] Testing database backup network path \US00SSQL03\Backup\AirWatch_DB10
VERBOSE: [16:01:33][Connect-DbaInstance] String is passed in, will build server object from instance object and other parameters, do some checks and then return the server object
VERBOSE: [16:01:33][Connect-DbaInstance] authentication method is 'local ad'
VERBOSE: [16:01:34][Invoke-DbaDbLogShipping] Database backup network path \US00SSQL03\Backup\AirWatch_DB10 not found. Trying to create it..
VERBOSE: [16:01:34][Invoke-Command2] Creating backup folder \US00SSQL03\Backup\AirWatch_DB10
WARNING: [16:01:34][Invoke-DbaDbLogShipping] Something went wrong creating the backup directory | The FileSystem provider supports credentials only on the New-PSDrive cmdlet. Perform the operation again without specifying credentials.
VERBOSE: [16:01:34][Invoke-DbaDbLogShipping] Finished setting up log shipping.
Steps to Reproduce
PS C:\Users\xishen> $params = @{
SourceSqlInstance = 'US00SSQL03'
DestinationSqlInstance = 'US00SSQL02'
Database = 'AirWatch_DB10'
SharedPath= '\US00SSQL03\Backup'
SourceCredential= 'SDAD\svcAnsibleSDAD'
DestinationCredential= 'SDAD\svcAnsibleSDAD'
LocalPath= 'W:\MSSQL14.MSSQLSERVER\MSSQL\Backup'
}
Invoke-DbaDbLogShipping @params
Please confirm that you are running the most recent version of dbatools
1.1.143
Other details or mentions
I think Powershell isnt happy with passing in credential to new-item anymore. is it possible to remove it or find a workaround? I tried to run the command without credential on https://github.com/dataplat/dbatools/blob/master/public/Invoke-DbaDbLogShipping.ps1#L929 and it worked correctly
What PowerShell host was used when producing this error
Windows PowerShell ISE (powershell_ise.exe)
PowerShell Host Version
Name Value
PSVersion 5.1.17763.5576
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.17763.5576
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1
SQL Server Edition and Build number
Microsoft SQL Server 2019 (RTM-CU25) (KB5033688) - 15.0.4355.3 (X64) Jan 30 2024 17:02:22 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2019 Datacenter 10.0 (Build 17763: ) (Hypervisor)
.NET Framework Version
.NET Framework 4.8.4645.0
The text was updated successfully, but these errors were encountered: