Hi everybody,

                     Here i want a solution for this question.

                    I want to split a Large datafile in to two datafiles with out causing any effect to the application and doesn't effects the performance.

 

Thanks for all,

---

Venu gopal.K
India.

What sql server are you using?

You can add a new file to the filegroup and data will get put in there if the first is filled or restricted. Or you can make a new filegroup and specifically move tables and or indexes into it.