Moving AS Database RRS feed

  • Question

  • Hi all,

    I have to move the main Enterprise as database from the C drive to the D drive on the same server.

    Anyone highlight any possible problems/gotcha's I may run into.

    Cannot believe the cowboys created an enterprise wide Datawarehouse on a C drive.....

    Tuesday, February 1, 2011 9:24 AM


All replies

  • Just one comment:  Check the Cube ID , if there is no same id then it may run a problem
    Tuesday, February 1, 2011 11:45 AM
  • If you mean the datawarehose (mdf and ldf) files you can look at this blog http://weblogs.sqlteam.com/dang/archive/2009/01/18/Dont-Use-sp_attach_db.aspx .

    If you want to move the cube you can set the StorageLocation property of the cube. But analysis server's AllowedBrowsingFolders property must be set before setting the storage location.

    Hope it helps,


    Erdem Zengin

    • Marked as answer by Jerry Nee Tuesday, February 15, 2011 2:08 AM
    Tuesday, February 1, 2011 10:46 PM