ÿþ<html> <head> <title>Add-SqlDatabase</title> </head> <body> <h1>Add-SqlDatabase</h1> <div>Adds a new database to a SQL Server.</div> <h2> Syntax </h2> <code>Add-SqlDatabase [-sqlserver] &lt;Object&gt; [-dbname] &lt;String&gt; [[-dataName] &lt;String&gt;] [[-dataFilePath] &lt;String&gt;] [[-dataSize] &lt;Double&gt;] [[-dataGrowthType] {KB | Percent | None}] [[-dataGrowth] &lt;Double&gt;] [[-dataMaxSize] &lt;Double&gt;] [[-logName] &lt;String&gt;] [[-logFilePath] &lt;String&gt;] [[-logSize] &lt;Double&gt;] [[-logGrowthType] {KB | Percent | None}] [[-logGrowth] &lt;Double&gt;] [[-logMaxSize] &lt;Double&gt;] [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Add-SqlDatabase function Adds a new database to the specified SQL Server. </div> <h2> Related Commands </h2> <div> * <a href='Add-SqlDatabase.htm'>Add-SqlDatabase</a><br/> </div> <h2> Parameters </h2> <table border='1'> <tr> <th>Name</th> <th>Description</th> <th>Required?</th> <th>Pipeline Input</th> <th>Default Value</th> </tr> <tr valign='top'> <td>sqlserver&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>dbname&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>dataName&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>dataFilePath&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>dataSize&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>dataGrowthType&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>dataGrowth&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>dataMaxSize&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>logName&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>logFilePath&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>logSize&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>logGrowthType&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>logGrowth&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>logMaxSize&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> </table> <h2> Input Type </h2> <div>None You cannot pipe objects to Add-SqlDatabase</div> <h2> Return Values </h2> <div>None This function does not generate any output.</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>Add-SqlDatabase "Z002\sql2k8" "NorthwindCopy"</pre> <div>This command adds the NorthwindCopy database to the Z002\sql2k8 server.</div> </body> </html>