Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?



Former Member
Not what you were looking for? View more on this topic or Ask a question