Database issue.... -- sql server clustering

Aner T. Ortega
6/24/2004 6:19:59 PM

Is there any way that we can use two drives on a single
database and server. Example, my database is located at
drive C and that drive becomes full. Is there anyway that
the data will automatically written to the second drive
(Drive D for example) without user intervervention? If
so, what will be the setting for the server.

As of now, my first hard disk becomes low on resources
and I want the data to be written to the second drive
without removing the data on the first drive.

Geoff N. Hiten
6/25/2004 10:10:31 AM

You can add files and filegroups to manage your data growth at the database
level. Splitting data across different disks is a long-standing performance
tuning tool. Look in BOL (Books On-Line) on the topic Files and Filegroups.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

sql server clustering : Database issue....