Post reply

Issue in reading file stream data using PathName() from filestream column in SQL 2012

  • November 9, 2015 at 5:10 am

    #302166

    Hi Experts,

    We have seen some strange output while reading filestream column using PathName().

    Some VolumeHint-HarddiskVolume17 is getting appended at the end of filestream path and hence our applications are unable to read the path while starting archiving process where old file from DB are archived from DB to Disk.We refreshed filestream database from production to test environment and testing the applications.When we execute the same query in production we are getting path without these VolumeHint.

    Volumehints keep on changing whenever we are recycling SQL server.In end its coming to VolumeHint-HarddiskVolume52,VolumeHint-HarddiskVolume41

    Does anyone faced this issue?Need your expert advise on this.

    Attaching snapshots of output.

    Regards,

    Bipan

  • November 9, 2015 at 12:38 pm

    #1838660

    Hi All,

    I got an answer to my question.PathName() will return logical path of our filestream data stored in physical disks.

    Find the answer in attached snapshots for more clarity.

    Regards,

    Bipsy

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

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