djj (3/16/2015)
In case of failover, while using log shipping, how does the naming convention work? Should our log shipped database have the same name as the production?
A log shipped secondary database does not have to have the same name as the primary
djj (3/16/2015)
Since SQL Server takes the name of the server for part of the instance name, how does that work?
You'll likely need to use CNAME records for aliasing server names.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉