Post reply

db files issue

  • June 29, 2010 at 12:46 am

    #147704

    folks

    in our production server i checked

    use abc

    sp_helpfile

    o/p: it is showing like this how it is shows 2 Data and 2 Log files with in the same database?

    Name sizes File Path

    texa_Data 4211328KB D:\SQL2000\RMS_Data.MDF

    texa_Log 975104KB D:\SQL2000\RMS_Log.LDF

    abc_1_Data2368KB E:\rmsdb_weekly_backup\rms db weekly bkp abc_1_Log8kb E:\rmsdb_weekly_backup\rms_weekly_db backup

    i could not understand these two files

    abc_1_Data 2880 KB

    abc_1_Log 8 KB

    how to deal with these files,

    if i restore db also i am consider these files path

    let me know how to isolate these files.

  • June 29, 2010 at 1:37 am

    #1186197

    I'm not sure I understand what you mean, but they look like the logical file names, associated with a physical file. You don't have two data files and two log files, the just have "two names".

    Take a look here to learn more on logical and physical file names: http://msdn.microsoft.com/en-us/library/ms179316.aspx

    -- Gianluca Sartori

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

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