Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raveekumarg
Starting Member
36 Posts |
 Posted - 2009-02-06 : 01:41:08
|
| dear alli am using sql 2k,due to huge mdf size growth we have planed to add addtional drive in the server...my ldf,mdf is in the same(old) path...now i want to create another primary data file in the new path...and another thing it is a production server, without affecting the business how can i do it...suggestion pl.ravi |
|
|
raveekumarg
Starting Member
36 Posts |
Posted - 2009-02-06 : 02:14:01
|
| stuff guys pl help me out..very urgent...ravi |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-06 : 09:21:59
|
| You can create Secondary Filegroup(with new data files(NDF)) and put in new drive. |
|
|
|
|
|
|
primary data file