Post reply

Resizing disk partition

  • October 15, 2009 at 2:30 pm

    #212123

    I want to resize the disk partition (E) where my SQL 2005 SP3 databases are stored. My program is on C: but all data files, IIS, etc. (not logs) are on E. This is a virtual server on a SAN blade.

    I think I can stop all services, copy all my files to a temporary partition, resize my E: and then copy them back and re-start services.

    Will this work OK?

    If not, suggestions are welcome. I looked for other posts and this seems to be the "process" so-to-speak.

    Thanks,

    Sandy

  • October 15, 2009 at 2:55 pm

    #1066542

    I've done that with database files dozens of times. As long as you stop SQL Server first, move the files to another temporary location, re-configure the E: drive and put everything back to the E: drive exactly as it was with all of the paths matching, you should be fine. When you restart SQL, it will find the database files exactly where they were when you stopped it, on the E: drive and in the same path.

  • October 15, 2009 at 3:13 pm

    #1066568

    Thanks for the response! I'm glad to know you've done it - makes me feel a bit better 🙂

    I'll post back afterwards to say how it all went in case anyone else is reading this.

    Cheers -

    Hawkeye_DBA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply