Export (0) Print
Expand All
Expand Minimize

Remove-SPProjectDatabase

Project Server 2013
 

Applies to: Project Server 2013

Topic Last Modified: 2013-12-18

Dismounts the Project Web App database from the site collection and drops it from SQL Server.

Remove-SPProjectDatabase [-Name] <String> [-WebApplication] <SPWebApplicationPipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-DatabaseServer <String>] [-WhatIf [<SwitchParameter>]]
Remove-SPProjectDatabase [-Name] <String> [-ServiceApplication] <PsiServiceApplicationPipeBind> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-DatabaseServer <String>] [-WhatIf [<SwitchParameter>]]

The Remove-SPProjectDatabase cmdlet dismounts the Project Web App database from the site collection and drops it from SQL Server. Use this cmdlet if you want to remove a mounted database that is not in use.

 

Parameter Required Type Description

Name

Required

System.String

Specifies the name of the Project Web App database.

ServiceApplication

Required

Microsoft.Office.Project.Server.Cmdlet.PsiServiceApplicationPipeBind

Specifies the Project Server service application from which the Project Web App database will be removed.

WebApplication

Required

Microsoft.SharePoint.PowerShell.SPWebApplicationPipeBind

Specifies the web application from which the Project Web App database will be removed.

AssignmentCollection

Optional

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

NoteNote:
When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

Confirm

Optional

System.Management.Automation.SwitchParameter

Prompts you for confirmation before executing the command. For more information, type the following command: get-help about_commonparameters

DatabaseServer

Optional

System.String

Specifies the name of the instance of SQL Server where the database is located.

WhatIf

Optional

System.Management.Automation.SwitchParameter

Displays a message that describes the effect of the command instead of executing the command. For more information, type the following command: get-help about_commonparameters

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft