Muokkaa

Jaa

Database Storage Location

  • Artikkeli

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

There are often situations when an SQL Server Analysis Services database administrator (dba) wants a certain database to reside outside of the server data folder. These situations are often driven by business needs, such as improving performance or expanding storage. For these situations, the DbStorageLocation database property enables the SQL Server Analysis Services dba to specify the database location in a local disk or network device.

DbStorageLocation database property

The DbStorageLocation database property specifies the folder where SQL Server Analysis Services creates and manages all the database data and metadata files. All metadata files are stored at the DbStorageLocation folder, with the exception of the database metadata file, which is stored in the server data folder. There are two important considerations when setting the value of DbStorageLocation database property:

  • The DbStorageLocation database property must be set to an existing UNC folder path or an empty string. An empty string is the default for the server data folder. If the folder does not exist, an error will be raised when you execute a Create, Attach, or Alter command.

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

Important

We recommend that set your UNC path to use a Storage Area Network (SAN), iSCSI-based network, or a locally attached disk. Any UNC path to a network share or any high latency remote storage solution leads to an unsupported installation.

DbStorageLocation compared to StorageLocation

DbStorageLocation specifies the folder where all the database data and metadata files reside, whereas StorageLocation specifies the folder where one or more partitions of a cube reside. StorageLocation can be set independently of DbStorageLocation. This is an SQL Server Analysis Services dba decision based on the expected results, and many times the usage of one property or the other will overlap.

DbStorageLocation Usage

The DbStorageLocation database property is used as part of a Create database command in a Detach/Attach database commands sequence, in a Backup/Restore database commands sequence, or in a Synchronize database command. Changing the DbStorageLocation database property is considered a structural change in the database object. This means that all metadata must be recreated and the data reprocessed.

Important

You should not change the database storage location by using an Alter command. Instead, we recommend that you use a sequence of Detach/Attach database commands (see Move an Analysis Services Database, Attach and Detach Analysis Services Databases).

See Also

Attach and Detach Analysis Services Databases
Move an Analysis Services Database
DbStorageLocation Element
Create Element (XMLA)
Attach Element
Synchronize Element (XMLA)