November 1, 2015 at 11:35 am
Please confirm that this would be a problem: Server1 has a prod-DB name ABC1 with logical file name ABC1_Data & ABC1_Log, on the same server I've created a test-DB with a logical file name test_data & test_log. Now when taking a backup from a different server (server2) and restoring it to test-db (server1) I notice the logical name from that backup on server server2 is called ABC1_Data & ABC1_Log just like on server1. If I apply the restore to the test-db on server1, it's logical files are going to be the same and conflict with the prod-DB because of there same logical name correct.
November 1, 2015 at 2:22 pm
Yes thats rite,similar Logical names are not allowed. But its possible to restore the full backup of same logical name backup copy with different logical name.
follow the link
https://technet.microsoft.com/en-us/library/ms190447(v=sql.105).aspx
@JayMunnangi
November 1, 2015 at 5:56 pm
It's not a problem, you'll be fine.
Logical file names only have to be unique within a database, not within an instance. Two databases with the same logical names for files on the same instance is allowed and will cause no problems.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2015 at 5:57 pm
JakDBA (11/1/2015)
Yes thats rite,similar Logical names are not allowed. <snip>follow the link
https://technet.microsoft.com/en-us/library/ms190447(v=sql.105).aspx
You may want to check links before you post next time. That shows how to restore with a different *database* name and different *physical* names for the files.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 2, 2015 at 6:59 am
well... thats for basic understanding.
@JayMunnangi
November 2, 2015 at 7:44 am
JakDBA (11/1/2015)
Yes thats rite,similar Logical names are not allowed. But its possible to restore the full backup of same logical name backup copy with different logical name.follow the link
https://technet.microsoft.com/en-us/library/ms190447(v=sql.105).aspx
Logical names may be used as many times as required, as Gail said they must be unique with the database only. The physical names must be unique across the instance, it's likely these that were causing an issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply