Post reply

Does sql view a folder path to data file the same as mount point path to data file

  • June 20, 2011 at 1:00 pm

    #145821

    We have several of our database files located on mount points e.g. K:\split_data\cm_data\datafile01.ndf

    If we change our disk environment, removing mount points but have the exact same folder structure /path to the data files should we expect the database to come back online?

  • June 21, 2011 at 5:23 am

    #1341741

    Indianrock (6/20/2011)

    We have several of our database files located on mount points e.g. K:\split_data\cm_data\datafile01.ndf

    If we change our disk environment, removing mount points but have the exact same folder structure /path to the data files should we expect the database to come back online?

    if path is exactly the same like going from...

    K:\split_data\cm_data\datafile01.ndf

    to

    K:\split_data\cm_data\datafile01.ndf

    ...then the answer is yes.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • June 21, 2011 at 5:40 am

    #1341752

    Thank you very much.

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

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