i am trying to get log shiping setup on one of our servers, but when i try to complete the job, it says server name GRNSQL004 does not exist
which in fairness, it does not exist, the primary server i am working on is called grnsql001
but when i select @@servername i get GRNSQL004..
how do i go about fixing this? i can read online about dropserver, but the very name makes me fearful of trying as this is my main business critical sql server