Database Reference
In-Depth Information
<DatabaseID>ssas_cookbook_chapter3</DatabaseID>
</Object>
</Detach>
3. After you run the command, you will find a file named
ssas_cookbook_chapter3.detach_log in the Database folder.
To attach a previously detached database, perform the following steps:
1. Connect to the target SSAS instance (or the same instance from which you
previously detached the database) and choose Attach .
2. If you encrypted the database prior to detaching, you must provide the pass-
word.
3. Specify the full path to the folder with the detached database. You have an
option to attach the database from its current location (without copying any
files) or from a different location after you copy the database files to that loc-
ation.
4. If you script the Attach command, it will look similar to the following code
snippet:
<Attach xmlns =
"http://schemas.microsoft.com/
analysisservices/2003/engine">
<Folder>E:\Program Files\Microsoft SQL
Server\MSAS11.SQL2012\OLAP\Data\ssas_cookbook_chapter3.0.db</Folder>
<ReadWriteMode xmlns =
"http://schemas.microsoft.com/
analysisservices/2008/engine/
100">ReadOnly</ReadWriteMode>
</Attach>
5. If you prefer to attach in the read-write mode, simply replace Readonly with
ReadWrite within the command previously shown.
Search WWH ::




Custom Search