January 18, 2009 at 10:19 am
Hello All,
Today I was trying to set up log shipping. This failed because the name of the sql server instance was conflicting with m\c name as I was using the local instance instead of named instance. I executed SELECT @@servername which gave me following information.
PRODSERVER
According to the logshipping setup error I wanted to change this value to 'MISSIONCRITICAL'. To achieve this I had to change my computer name to 'MISSIONCRITICAL'. Is there any other way to achieve this. I am pretty sure that there should be one table in the master database that could be updated to achieve this. I googled but could not find anything encouraging.
-M
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
January 19, 2009 at 1:36 am
Can you provide more details about what your entries are? How is the name of your primary server? What is the name of your secondary server? Any screenshots?
Maybe this helps: http://sqlserveruniverse.com/content/ADMN0100111132007LogShipping.aspx
January 19, 2009 at 4:21 am
Default instance should not be a problem to set up the logshipping. More detail about your issue will help to guide you.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 24, 2009 at 7:21 pm
I think my straight question should be:
If my servername <> my m\c name. Then how to change my server name = my m\c name. There is only one named instance.
-M
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply