I have a huge database which is configured about 216 phisical files distributed in drives L,M,N and O. in this last drive O resides 61 of these files, I need to dismount drive O, so how can I Move ths 61 files for example to H drive?
with smaller databases I have done this with sp_attach_db and sp_detach_db, but I Noticed that this sps just works with 16 files. so I cannot use it.
Can I go directly to system table sysfiles and update O:\ with H:\ ? is that risky ?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.