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 |
|
ballabhoks
Starting Member
18 Posts |
 Posted - 2004-01-27 : 08:12:05
|
| Can we change the path of primary or secondary file group. Actually, by mistake I have created a database in I drive while database needs to be created in E drive. My database contains one MDF and 17 NDF files and path for all NDF is also in I drive. |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-01-27 : 08:58:19
|
| You may have to detahc the database using sp_detach_db, move the files between drives, then use sp_attach_db to reconnect the database. Check BOL for the correct syntax for these commands.Raymond |
 |
|
|
|
|
|
Change path of Primary or Secondary group