Multiple Hard Drives 1

[vb5prgrmr]

Win 2k Enterprise Server Running both SQL 7.0 Enterprise and SQL 2k Enterprise (7 is disabled).

Now, I know that I can place the .log file and data on different hard drives. I also know that I can, if necessary, create multiple databases on different drives, but what I want to know is... Is it possible to alter the creation script to specify a single table to be created on a different drive while maintaining the single database?
[tt]
CREATE TABLE tblWhatever…
[/tt]

Before you go asking WTF? Why..? Let me just say that when I accepted this task, I figured the "test data" that I would receive would be no problem. Go figure... I get this package with so many disks in it that... Well you can imagine the bodily functions.

The database table that I am having problems with in itself contains a lot of statistical information that while any one single record in rarely updated, a good portion of them are used for the analysis. So I have to load the entire set of disks and my little ol’ test bed machine is not capable of holding the data on any one of its drives.

If this can’t be done just tell me that I’m SOL and I will go ahead and go with the multiple database scheme. Then when I deliver the final product I'll just go ahead and make the adjustments.

Thanks for reading…

 

[TallOne]

Just a suggestion...You might be able to do this(Partitioning a SQL Server Database Table in 2005) if you upgrade to SQL 2K5 for development and then later downgrade to 2K for deployment. Sounds like a lot of work though.

 

[gmmastros]

I've never done it, but you can create multiple filegroups with SQL 2000.

http://msdn.microsoft.com/en-us/library/aa174545(SQL.80).aspx

Take a look at that page, and do some additional research. Hopefully this will be enough to get you started.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[vb5prgrmr]

gmmastros,

See, I knew I had read something like that before! I just could not remember where to find it. And now that I know what I'm looking for I was able to find it in the help files. I just did not think to look there since the script was provided. Dummy me! I'll just have to chalk it up to another BF (Brain Fart!)

Thanks for the point in the right direction. (Yaaa!) (now i'll have to disconnect and archive to disk other past projects).

Thanks once again.

 

[gmmastros]

Glad to help.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom