Move Physical Files

  • opc.three (4/9/2012)


    If I have two data files in my database, both on D:\, and I want to move one to E:\ and one to F:\, if I run an alter to move one to E:\ but I forget to move the other one to F:\ the database will happily come online with one data file on D:\ and one on E:\.)

    if you left the old file in place yes it would. If you moved the file instead of copying it would fail to come online.

    Look it's your opinion and you're entitled to it, at the end of the day it's unnecessary to go single user first just take the data straight offline.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry Whittle (4/9/2012)


    opc.three (4/9/2012)


    If I have two data files in my database, both on D:\, and I want to move one to E:\ and one to F:\, if I run an alter to move one to E:\ but I forget to move the other one to F:\ the database will happily come online with one data file on D:\ and one on E:\.)

    if you left the old file in place yes it would. If you moved the file instead of copying it would fail to come online.

    I never said otherwise.

    Look it's your opinion and you're entitled to it

    I feel like I should thank you for allowing me my opinion :hehe:

    at the end of the day it's unnecessary to go single user first just take the data straight offline.

    Agreed (note: this is the second time I am agreeing with you on this point).

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 16 through 17 (of 17 total)

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