Comments (1)
csommerolo
commented on June 11, 2024
This is not identical but similar to an issue we faced with the Copy-DbaAgentServer cmdlet. We noticed that none of our alerts copied from source to destination the first time we ran it. Everything else copied fine, just the alerts were missed. No errors were thrown and it appeared to be successful, but it was not. We re-ran it and the alerts were successfully copied over on the second run.
There are a lot of .Refresh() method calls in that cmdlet. And they even fully reconnect after copying the operators so I feel like they were trying to account for this weirdness.
# extra reconnect to force refresh
$destServer = Connect-DbaInstance
At first we thought it was an order of operations thing but this kinda feels like SMO being buggy. I have one more set of servers to upgrade so I'm going to try to capture more information when we do that.
Additional context. We are upgrading SQL 2016 -> SQL 2022.
from dbatools.
Related Issues (20)
- Backup-DbaDatabase : add a switch that will prevent to always append dbname in the directory backup path and strictly respect the given path variable.
- Get-DbaRegServer - SSMS upgraded from 19.x to 20.1, reading "old" RegisteredServersStore
- Add command to set the instance authentication mode
- Get-DbaHideInstance does not work on a system with named instance HOT 2
- Get-DbaDbBackupHistory - exception on data source length in connection HOT 5
- Issue with creating new directory when Invoke-DbaDbLogShipping. HOT 1
- Find-dbadbunusedindex | write-dbadbtabledata - Incorrect syntax near ')' HOT 7
- Azure Automation Account - issue loading the module HOT 6
- Odd Experience when using Connect-DbaInstance HOT 3
- Test-DbaWindowsLogin add property on account name mismatch HOT 3
- Invoke-DbaQuery's parameter list is oddly formatted. This appears to break the online docs and Get-Help. HOT 9
- Update-DbaInstance can not use secure PS Remoting HOT 1
- dbatools.io / github Slack Invite has expired (again) HOT 1
- Copy-DbaAgentJob fails when trying to copy CDC jobs HOT 3
- New-DbaAgentJobStep -DatabaseUser is not setting the username for the job. HOT 2
- Exception: Couldn't import C:\Program Files\WindowsPowerShell\Modules\dbatools.library\2024.4.12\core\lib\win-sqlclient\Microsoft.Data.SqlClient.dll | Assembly with same name is already loaded
- Warning after run Get-Dbatoolsconfig or Find-DbaInstance on Windows Server 2016 HOT 1
- Restore-DbaDatabase with -Continue when Database has Memory Optimized File Group and/or multiple differential_base_lsn
- Behavior of `Get-DbaDatabase -Database DoesNotExist` HOT 1
- New-DbaAgentSchedule flags an error with a start time before 10000? HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbatools.