Attaching Issue..

  • Hi All,

    Am using SQL 2008 and 2012,

    Ex: My Db name is SampleDb (SampleDB1.mdf,SampleDB1_log.ldf)

    I have Detached and Attached the Database with the name of SampleDB_New.But the thing is mdf and ldf names are same(SampleDB1.mdf,SampleDB1_log.ldf) after Attaching Database.

    Here I have a question i.e if i attach with the new name whether the names of Mdf and ldf will change or not?

    Regards

    Jagadeesh

    Regards
    Chowdary...

  • It doesn't change I believe.

  • Assuming you're talking about two different server instances and two different sets of file locations so that each server is pointing to a different file, the names don't need to change. If you try to point both servers to the same files in the same location, you're going to hit issues.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Physical files name won't change until you change them manually.

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

  • Thank U All for giving the reply.

    Actually my problem is one of my colleague had created the database with his name (Ex:Chinna),Now my Boss asked me to change the name of the DB name .So i have renamed that DB name (Chinna to Employee),But the Mdf and Ldf names are same as previous.So now i want to change the names of that 2 files .

    is there any issue with that?

    is there any chances to change ?

    If i change the names manually is there any issues?

    Please help me.........

    Regards

    Jagadeesh....

    Regards
    Chowdary...

  • You can change it manually.

  • Joy Smith San (6/27/2014)


    You can change it manually.

    Yes

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 7 posts - 1 through 6 (of 6 total)

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