Export (0) Print
Expand All
Expand Minimize

DbStorageLocation Element

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


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

Characteristic

Description

Data type and length

String

Default value

""

Cardinality

0-1: Optional element that can occur one time only.

Relationship

Element

Parent elements

Database

Child elements

None

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft