SQL Server Developer Center > SQL Server Forums > SQL Server Analysis Services > moving SSAS 2005 database to another drive
Ask a questionAsk a question
 

Answermoving SSAS 2005 database to another drive

  • Tuesday, September 25, 2007 10:46 AMjan.zajic Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

     

    Hello,

     

    how can I move the SSAS 2005 database to another drive ? The reason is, I´m running out of space on the current drive.

    Thanks a lot for an answer.

Answers

  • Tuesday, September 25, 2007 7:57 PMAdrian Dumitrascu Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer

    Hi,

    You can change the Data folder for AS2005, to move all the databases to another location (you cannot have separate locations for databases on the same AS2005 instance). To do that:

    1. use the server's properties dialog to specify the new path (from SQL Management Studio, connect to AS2005, right click on the server, Properties, DataDir property) (the change will not become effective immediately, no actual data will be moved)

    2. stop AS2005

    3. move the Data directory to the drive you want

    4. restart AS2005

All Replies

  • Tuesday, September 25, 2007 7:57 PMAdrian Dumitrascu Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer

    Hi,

    You can change the Data folder for AS2005, to move all the databases to another location (you cannot have separate locations for databases on the same AS2005 instance). To do that:

    1. use the server's properties dialog to specify the new path (from SQL Management Studio, connect to AS2005, right click on the server, Properties, DataDir property) (the change will not become effective immediately, no actual data will be moved)

    2. stop AS2005

    3. move the Data directory to the drive you want

    4. restart AS2005