ÿþ<html> <head> <title>Invoke-SqlBackup</title> </head> <body> <h1>Invoke-SqlBackup</h1> <div>Performs a SQL database or log backup.</div> <h2> Syntax </h2> <code>Invoke-SqlBackup [-sqlserver] &lt;Object&gt; [-dbname] &lt;String&gt; [-filepath] &lt;String&gt; [[-action] {Database | Files | Log}] [[-description] &lt;String&gt;] [[-name] &lt;String&gt;] [[-force]] [[-incremental]] [[-copyOnly]] [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Invoke-SqlBackup function performs a SQL database or log backup of the specified database. </div> <h2> Related Commands </h2> <div> * <a href='Invoke-SqlBackup.htm'>Invoke-SqlBackup</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>filepath&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>action&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>description&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>name&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>force&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>incremental&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>copyOnly&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 Invoke-SqlBackup</div> <h2> Return Values </h2> <div>None This function does not generate any output.</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>Invoke-SqlBackup "Z002\sql2k8" "pubs" "C:\sqlrec\pubs.bak"</pre> <div>This command backs up the pubs database to disk.</div> </body> </html>