SAinCA, Thank you for the question. It is a valid one and a new technique in SQL Server that can reap numerous benefits. Here are 2 tips with information on SQL Server 2005 filegroups: Using Multiple Filegroups http://www.mssqltips.com/tip.asp?tip=967 Filegroups in SQL Server 2005 http://www.mssqltips...

Hi, Thanks for the reply. But I'm working on SQL Server 2000 & need a solution for the same problem in SQL Server 2000. My OS is Windows Server 2003 I'm sorry I forgot to mention this beforehand. Would appreciate if any fellow member can guide me to a solution. Ankit Mathur