DbStorageLocation Element
TOC
Collapse the table of content
Expand the table of content

DbStorageLocation Element

 

Applies To: SQL Server 2016 Preview

Specifies the folder where Analysis Services creates and manages all the database data and metadata files.

  
<Database>  
...  
   <ddl100_100:DbStorageLocation>...</ddl100_100:DbStorageLocation>  
...  
</Database>  

CharacteristicDescription
Data type and lengthString
Default value""
Cardinality0-1: Optional element that can occur one time only.
RelationshipElement
Parent elementsDatabase
Child elementsNone

The DbStorageLocation database property must be set to an existing UNC folder path or an empty string. An empty string is the default server data folder. If the folder doesn't exist, an error will be raised when executing a Create, Attach, or Alter command.

In addition, the DbStorageLocation database property cannot be set to point to the server data folder or any of its subfolders. If the location points to the server data folder or any of its subfolders, an error will be raised when executing a Create, Attach, or Alter command.

DbStorageLocation
Attach and Detach Analysis Services Databases

Community Additions

ADD
Show:
© 2016 Microsoft