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.

Thanks.

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

"Aner T. Ortega" <atortega (AT) yahoo (DOT) com> wrote