dynamic partitions

Can you format a partition as "dynamic" and use SQL server on it?
I currently have a windows 2003 server connected to a SAN.
Local disk (drive C) on the server is a basic partition.
drives D and E are on the EMC storage but partitioned as "dynamic".
Before I get too far, will I have a problem with SQL server loaded on the
local C drive (basic partition) storing files out on the D and E drive
(dynamic partitions)?
Thanks--Mark ThorsenIf you are using a failover cluster, you would have a problem. See this KB
article http://support.microsoft.com/?id=237853. It states:
"Windows 2000 Advanced Server, Windows 2000 Datacenter Server, Windows
Server 2003 Enterprise Edition and Windows Server 2003 Datacenter Edition
support only basic shared disks in an environment that uses the Windows
Server failover clustering feature."
Linchi
"Thorsen" wrote:

> Can you format a partition as "dynamic" and use SQL server on it?
> I currently have a windows 2003 server connected to a SAN.
> Local disk (drive C) on the server is a basic partition.
> drives D and E are on the EMC storage but partitioned as "dynamic".
> Before I get too far, will I have a problem with SQL server loaded on the
> local C drive (basic partition) storing files out on the D and E drive
> (dynamic partitions)?
> Thanks--Mark Thorsensql

dynamic partitions

Can you format a partition as "dynamic" and use SQL server on it?
I currently have a windows 2003 server connected to a SAN.
Local disk (drive C) on the server is a basic partition.
drives D and E are on the EMC storage but partitioned as "dynamic".
Before I get too far, will I have a problem with SQL server loaded on the
local C drive (basic partition) storing files out on the D and E drive
(dynamic partitions)?
Thanks--Mark ThorsenIf you are using a failover cluster, you would have a problem. See this KB
article http://support.microsoft.com/?id=237853. It states:
"Windows 2000 Advanced Server, Windows 2000 Datacenter Server, Windows
Server 2003 Enterprise Edition and Windows Server 2003 Datacenter Edition
support only basic shared disks in an environment that uses the Windows
Server failover clustering feature."
Linchi
"Thorsen" wrote:
> Can you format a partition as "dynamic" and use SQL server on it?
> I currently have a windows 2003 server connected to a SAN.
> Local disk (drive C) on the server is a basic partition.
> drives D and E are on the EMC storage but partitioned as "dynamic".
> Before I get too far, will I have a problem with SQL server loaded on the
> local C drive (basic partition) storing files out on the D and E drive
> (dynamic partitions)?
> Thanks--Mark Thorsen

Dynamic Cube partitioing in MSAS2000

Hi,

Pl give me a way, by which i can dynamically make the cube's partitions. Actully every month on start i have to create a partition for that month manully. Can it make it automatic by any way?

Pl help me for this regard i need it urgently.

Thank and Regards

Abhishek

SQL Server Integration Services has a Analysis Services Execute DDL task which can be used to create partitions. The DDL for this task can be created by a script task which takes a template DDL and inserts the month specific information such as the partition name and ID and it's source table. You can then use the Analysis Services Processing Task to process those partitions. These tasks can be part of a scheduled SSIS package.

|||

Hi Matt,

Thanks for your response, But i am working in MS AS 2000. Pl help me for SQL Server 2000 reference.

Regards

Abhishek

|||Sorry, I missed that. Analysis Services 2000 can work with SQL Server Data Transformation Services in a similar fashion. You'll want to create a script task and use DSO to create the partitions and then yo can use the AS Processing task to process it.|||

Hi Carroll,

Thanks a lot to give me a way as DSO. It will be helpful for me if you send some demo code of "how to use it" and specially, how to use it using 'DTS'.

Regards

Abhishek