Invoke-SqlBackup
Performs a SQL database or log backup.
Syntax
Invoke-SqlBackup [-sqlserver] <Object> [-dbname] <String> [-filepath] <String> [[-action] {Database | Files | Log}] [[-description] <String>] [[-name] <String>] [[-force]] [[-incremental]] [[-copyOnly]] [<CommonParameters>]
Detailed Description
The Invoke-SqlBackup function performs a SQL database or log backup of the specified database.
Related Commands
Parameters
| Name |
Description |
Required? |
Pipeline Input |
Default Value |
| sqlserver |
|
true |
false |
|
| dbname |
|
true |
false |
|
| filepath |
|
true |
false |
|
| action |
|
false |
false |
|
| description |
|
false |
false |
|
| name |
|
false |
false |
|
| force |
|
false |
false |
|
| incremental |
|
false |
false |
|
| copyOnly |
|
false |
false |
|
Input Type
None
You cannot pipe objects to Invoke-SqlBackup
Return Values
None
This function does not generate any output.
Examples
EXAMPLE 1
Invoke-SqlBackup "Z002\sql2k8" "pubs" "C:\sqlrec\pubs.bak"
This command backs up the pubs database to disk.