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

    Question

  •  

    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