Post reply

sys.database_files (amd master_files) physical_name oddness

  • February 3, 2012 at 8:22 am

    #254749

    Any idea why physical_name entries would be listed as "E:\\SQL_Data\\db_file.mdf"

    rather than "E:\SQL_Data\db_file.mdf"?

    I have three DB's out of 32 on my acceptance server with this oddity. All the files (mdf, ndf and ldf) show up this way for these three.

    This does not appear to be impacting functionality at all.

  • February 3, 2012 at 8:44 am

    #1442469

    Pam Brisjar (2/3/2012)

    Any idea why physical_name entries would be listed as "E:\\SQL_Data\\db_file.mdf"

    rather than "E:\SQL_Data\db_file.mdf"?

    I have three DB's out of 32 on my acceptance server with this oddity. All the files (mdf, ndf and ldf) show up this way for these three.

    This does not appear to be impacting functionality at all.

    When the database was created, may be the DBA provided the file path in that way. That's why they are recorded like that in system. However, this will not put any impact on functionality.

    You can try to do it on some test server.

    BACKUP DATABASE YourDatabaseName TO DISK = 'E:\\BackupFolderName\\YourDatabaseName.BAK'

    It will work just fine. Similarly, when you will fetch the backup history data from BackupMediaFamily you will see the physical_device_name stored in the same way that you had provided in the backup code above.

    Sujeet Singh

  • February 3, 2012 at 8:45 am

    #1442470

    Duplicated the above post.

    Sujeet Singh

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

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