June 26, 2014 at 11:10 pm
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...
June 27, 2014 at 2:01 am
It doesn't change I believe.
June 27, 2014 at 4:40 am
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
June 27, 2014 at 6:47 am
Physical files name won't change until you change them manually.
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
June 27, 2014 at 7:31 am
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...
June 27, 2014 at 8:41 am
You can change it manually.
June 27, 2014 at 2:50 pm
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