dsccommunity / dsccommunity/SqlServerDsc
SqlDatabaseFile: New resource proposal
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
SqlDatabaseFile
I would like to see a new resource SqlDatabaseFile which can add and modify data file and/or log file.
Comments on this appreciated.
Description
I can see this resource take multiple names of files. So it can create one file or several files depending on the users requirement. But I think the resource should not create Log and Data files at the same time. User should implement two steps n the configuration file for adding both log and data files.
I don't see this module to be able to move data or log file to a new path, maybe that can be a improvement. With modify I mean it can make sure sizes are always the same, if user wants that.
Usage
I personally want to be able to use this to modify the tempdb as well as other databases.
Schema suggestion
ServerName - The host name of the SQL Server.
InstanceName - The instance name of the SQL Server. Default is 'MSSQLSERVER'.
Ensure - If the file should me present or absent, and if it present if the sizes should be enforced. Valid values are 'Present', 'PresentAndSize', 'Absent'.
Name - Name of the file. Will be used as name and display name.
Path - The path where file will be created. It defaults to the path of the first file returned.
FileType - The type of file to create. Valid values are 'DATA','LOG'. Defaults to 'DATA'.
FileGroup - The file group to add the data file to. Defaults to 'PRIMARY'. Ignored if -FileType is 'LOG'.
GrowthType - The auto growth type. Valid values are 'Percent' or 'MB'.
Growth - The auto growth size for the file. Value is in percent or MB depending of -GrowthType.
IntialSize - The initial size of the file in MB. If -Ensure is set to 'PresentAndSize' then the initial size will be tried to be enforced.
MaxSize - The max size of the file in MB, or -1for unlimited size. If -Ensure is set to 'PresentAndSize' and -MaxSize does not equal -1 then the max size will be tried to be enforced.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing the proposed SqlDatabaseFile schema and usage requirements in the issue. No implementation files, tests, or entry points are identified; the work is not ready until the resource scope, behavior for data and log files, and acceptance criteria are agreed.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100