Replies: 1 comment
-
Hey @dvsrk - this command will do it for you. Generally, I use SMO (the DLLs that power SSMS) but in this case, it seems SMO was giving me issues so I used T-SQL https://github.com/sqlcollaborative/dbadisa/blob/master/public/Set-DbsDbFileSize.ps1 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I would like to update properties of the database file, something like file growth, max file size and name. Is there a way I could do that using any of the dbatools command?
I was looking in the below direction but not sure if it's the right approach,
Get-DbaDatabase -SqlInstance . | where name -EQ 'Test01' | select -ExpandProperty FileGroups | select -ExpandProperty files | get-member | where name -EQ 'SetPropertyValue'
Beta Was this translation helpful? Give feedback.
All reactions