"Chris" <Chris@discussions.microsoft.com> wrote in message
news:F3A8F622-9120-4FA1-B240-B2F051AFFB60@microsoft.com...
> Hi,
> I need your assistance with 2 questions:
>
> 1. I just got my new server and ready to setup as my warehouse (Data).
> It's
> has 2 logical drives:
> a. C: at 31GB
> b. D: at 260GB
>
> I installed SQL Server 2000 Analysis Server successfully. How can I move
> the
> data to be stored on the 260GB drive?
>
> 2. My second question is: When I delete a cube I don't see my drive space
> being recovered. How can I recover the drive space?
>
> Thanks

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:F3A8F622-9120-4FA1-B240-B2F051AFFB60@microsoft.com...
> Hi,
> I need your assistance with 2 questions:
>
> 1. I just got my new server and ready to setup as my warehouse (Data).
> It's
> has 2 logical drives:
> a. C: at 31GB
> b. D: at 260GB
>
> I installed SQL Server 2000 Analysis Server successfully. How can I move
> the
> data to be stored on the 260GB drive?
>
> 2. My second question is: When I delete a cube I don't see my drive space
> being recovered. How can I recover the drive space?
>
> Thanks

"Myles.Matheson@gmail.com" wrote:

> Hello Immy
>
> You can specify the location databases and cubes after installation of
> SQL 2000.
>
> Try this for changing the location of AS2000 data:
>
> 1. Select the Analysis Services Server in Analysis Manager
> 2. Right click and on the server icon select Properties
> 3. Under the general tab you can specify the location for the Analysis
> Services Cube location.
>
> Like wise you can also try the same steps for default location of SQL
> Server User databases.
>
> For existing SQL database follow Jeje's post. Its also important to
> note that you can specify the location of you SQL database in both
> T-SQL and Enterprise Manager.
>
> Hope this Helps,
>
> Myles Matheson
> Data Warehouse Architect
> http://bi-on-sql-server.blogspot.com/
>