Simone Bizzotto
Simone Bizzotto
@maxim-vde : glad that the "diagnosis" was right. I'd keep this open for another bit, some of the usual suspects may have a "contact" with the SMO team to see...
hum, I don't recall if they are enumed by database_id or listed alphabetically. Try with the very top and the very bottom db (by database_id and name). Ideally, `Where Name...
Perfect. Once again, @maxim-vde thanks a lot for your collaboration. Let us mumble on this a bit and we'll get back to you
@ben-thul : that's actually what dbatools Connect-DbaInstance does. Point here is that is faster for everything EXCEPT 2022.
lemme refrase... connect-dbainstance sets activeconnection as a default field, which improves performances for everything except 2022. setting it makes SMO (when the user has enough permissions) fetch data for all...
Well, let's make examples: - "I have 100 dbs on 2016. Doing Get-DbaDatabase -SqlInstance 2016 takes 4 seconds.". - "I have 100 dbs on 2022. Doing Get-DbaDatabase -SqlInstance 2022 takes...
hi @rferraton , are you able to backup manually to the path ? IMHO It's not a problem of dbatools per se, rather that sql can't have backup paths longer...
so, not a problem on dbatools, do you agree ?
ahem ... "Path" for sql is the full path, so both directory + filename . the 259 char limit is on the "sum" of both
that's just how dbatools composes the directory, it's going to break a lot of code to remove "dbname" from the path