SQL SERVER 2000, Move phisical database files from one drive to another



    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 ? 

    Thursday, July 24, 2008 3:31 PM

All replies