Add-SqlDatabase
Adds a new database to a SQL Server.
Syntax
Add-SqlDatabase [-sqlserver] <Object> [-dbname] <String> [[-dataName] <String>] [[-dataFilePath] <String>] [[-dataSize] <Double>] [[-dataGrowthType] {KB | Percent | None}] [[-dataGrowth] <Double>] [[-dataMaxSize] <Double>] [[-logName] <String>] [[-logFilePath] <String>] [[-logSize] <Double>] [[-logGrowthType] {KB | Percent | None}] [[-logGrowth] <Double>] [[-logMaxSize] <Double>] [<CommonParameters>]
Detailed Description
The Add-SqlDatabase function Adds a new database to the specified SQL Server.
Related Commands
Parameters
Name |
Description |
Required? |
Pipeline Input |
Default Value |
sqlserver |
|
true |
false |
|
dbname |
|
true |
false |
|
dataName |
|
false |
false |
|
dataFilePath |
|
false |
false |
|
dataSize |
|
false |
false |
|
dataGrowthType |
|
false |
false |
|
dataGrowth |
|
false |
false |
|
dataMaxSize |
|
false |
false |
|
logName |
|
false |
false |
|
logFilePath |
|
false |
false |
|
logSize |
|
false |
false |
|
logGrowthType |
|
false |
false |
|
logGrowth |
|
false |
false |
|
logMaxSize |
|
false |
false |
|
Input Type
None
You cannot pipe objects to Add-SqlDatabase
Return Values
None
This function does not generate any output.
Examples
EXAMPLE 1
Add-SqlDatabase "Z002\sql2k8" "NorthwindCopy"
This command adds the NorthwindCopy database to the Z002\sql2k8 server.