dsccommunity / dsccommunity/SqlServerDsc
Resource request - Take Offline / Bring Online
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
Details of the scenario you tried and the problem that is occurring
Would you consider creating a dsc resource for taking a database offline, as well as bringing it online?
I'd like to use a pure DSC approach for taking a copy of a database (its files) on one server, and copying them and attaching them on another.
-
Take database offline
-
Copy its files to some location (I can use standard file dsc resources for this)
-
Bring database back online
-
Drop any existing database on the other server (can use database resource for this)
-
Create a new database on this other server, by attaching the files copied from step 2. (think I can use database resource for this too)
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
Review the existing database DSC resource and the standard file DSC resources referenced in the issue to understand how they could support the proposed workflow. Define what 'done' means for taking a database offline and bringing it online, including the resource inputs and behavior needed for the copy-and-attach sequence.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100