Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue with creating new directory when Invoke-DbaDbLogShipping. #9355

Closed
xshen1 opened this issue May 16, 2024 · 1 comment · Fixed by #9359
Closed

Issue with creating new directory when Invoke-DbaDbLogShipping. #9355

xshen1 opened this issue May 16, 2024 · 1 comment · Fixed by #9359

Comments

@xshen1
Copy link

xshen1 commented 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'

BackupScheduleFrequencyType = 'daily'
BackupScheduleFrequencyInterval = 1
BackupScheduleFrequencySubdayType = 'Minutes'
BackupScheduleFrequencySubdayInterval = 15

CopyScheduleFrequencyType = 'daily'
CopyScheduleFrequencyInterval = 1
CopyScheduleFrequencySubdayType = 'Minutes'
CopyScheduleFrequencySubdayInterval = 15

RestoreScheduleFrequencyType = 'daily'
RestoreScheduleFrequencyInterval = 1
RestoreScheduleFrequencySubdayType = 'Minutes'
RestoreScheduleFrequencySubdayInterval = 15

CompressBackup = $true
NoRecovery = $true
GenerateFullBackup = $true

SecondaryDatabaseSuffix = ''
CopyDestinationFolder = '\\US00SSQL02\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
Screenshot 2024-05-16 at 4 45 38 PM

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

@xshen1 xshen1 added bugs life triage required New issue that has not been reviewed by maintainers labels May 16, 2024
@xshen1 xshen1 changed the title Issue with creating new directory when enabling logshipping. Issue with creating new directory when Invoke-DbaDbLogShipping. May 16, 2024
@andreasjordan
Copy link
Contributor

This looks like a bug. I will provide a pull request for that, but I can not test it.

@andreasjordan andreasjordan removed the triage required New issue that has not been reviewed by maintainers label May 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants