Need your assistance

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?
Thanksto move user databases (not system database like msdb, master, tempdb)
simply detach the database, move the MDF and LDF files to the D: then attach
the database from the new location.
read this:
http://support.microsoft.com/kb/224071/en-us
for AS, what are the size of your cubes? (sometimes the cubes are small so
you don't see the difference)
if you delete in the management interface and the data folder still contain
the deleted objects, you can delete the folder yourself.
but take care to delete ONLY the folder with the deleted objects
but...
BACKUP BACKUP BACKUP !!!!!
backup before you do anything a mistake can break everything.
"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|||I think Chris was asking how he can move his AS2000 Data to the D partition?
If so, then you should specify this at the point of installation.
You have the option to specify the data location during both SQL and AS
installation.
Immy
"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|||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/|||Since I am on this, I have read somewhere that for performance isues (IO) it
is recommended to put the data files and system databases on different
spindles. My question:
If I am using Raid 5 how can I achieve separate spindles? Isn't Raid 5 using
multiples drives as one or more logical drive which does not guarentee a
separate spindle?
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/
>