ÿþ<html> <head> <title>Add-SqlLogFile</title> </head> <body> <h1>Add-SqlLogFile</h1> <div>Adds a new LogFile to a database.</div> <h2> Syntax </h2> <code>Add-SqlLogFile [-database] &lt;Database&gt; [-name] &lt;String&gt; [-filepath] &lt;String&gt; [[-size] &lt;Double&gt;] [[-growthType] {KB | Percent | None}] [[-growth] &lt;Double&gt;] [[-maxSize] &lt;Double&gt;] [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Add-SqlLogFile function adds a new LogFile to the specified database. </div> <h2> Related Commands </h2> <div> * <a href='Add-SqlLogFile.htm'>Add-SqlLogFile</a><br/> * <a href='Add-SqlDatabase.htm'>Add-SqlDatabase</a><br/> * <a href='Get-SqlDatabase.htm'>Get-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>database&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>name&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>filepath&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>size&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>growthType&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>growth&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>maxSize&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-SqlLogFile</div> <h2> Return Values </h2> <div>Microsoft.SqlServer.Management.Smo.LogFile Add-SqlLogFile returns an Microsoft.SqlServer.Management.Smo.LogFile object.</div> <h2> Notes </h2> <div>Add-SqlLogFile is used by Add-SqlDatabase.</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>$database = Get-SqlDatabase "Z002\sql2k8" "pubs" Add-SqlLogFile -database $database -name 'pubs_LogFile1' -filepath 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2K8\MSSQL\DATA\pubs_LogFile1.ldf' $database.Alter()</pre> <div>This command adds the LogFile LogFile2 to the pubs database.</div> </body> </html>