New-DcnImage: Allow specifying a Recovery Model

[lowlydba]

Is your feature request related to a problem? Please describe.
I imagine most use cases will want a clone to be in simple recovery mode, so being able to change the model at image creation would be an ideal way to ensure this is passed down to clones.

[sanderstad]

That would be a nice feature but people do need to be aware to take caution when doing IO heavy stuff in the database because that could let the clone grow really large.

[lowlydba]

Maybe an easier (and more helpful) approach would be changing the temp DB name to a parameter (defaulting to the value used now) that way one could reliably reference it by name in their SQL script/file executed during image creation. That'd make any last-minute customization of the database very easy.

dbaclone/functions/image/New-DcnImage.ps1

Lines 630 to 631 in 0148b66

	# Setup the temporary database name
	$tempDbName = "$($db.Name)-dbaclone"

To allow for something like

$database = 'MyClone'
$tempDb = '$database-Temp123'
New-DcnImage -TempDb $tempDb ...

$sqlScript = "USE [master];
ALTER DATABASE [$tempDb] SET RECOVERY SIMPLE;"