Creating the datafiles in SQL2000
i am using SQL2000 with win2003server.
My query is, is that possible to create more datafiles in SQL2000?
i mean, currently i am having three datafiles with one logfile.
(i.e. prddata1.mdf,prddata2.ldf,prddata3.ldf and prdlog1.ldf)
i want to create the three more datafiles.
after creating the new datafiles, database growth should be with newly created datafiles only.
is there such concept exists in sql?