August 24, 2009 at 3:08 am
Hi all
I'm trying to configure log shipping for a database and am not able to because the srvname entry in the sys.sysservers table is not the same as the actual database.
Now, I did not install this database instance so my question is when and how does this table get updated and how has it ended up with an incorrect srvname?
This is SQL 2005 by the way.
Can anyone help me with this?
Cheers
Farren
August 24, 2009 at 3:37 am
fminns (8/24/2009)[/b]
Hi allI'm trying to configure log shipping for a database and am not able to because the srvname entry in the sys.sysservers table is not the same as the actual database.
I dint understand that point. Server name is not same as which data base you are saying?.
I think someone might have changed the PC name after installing the SQL server with default instance name. Probably you can "Drop" and "Add" the server and the problem might be solved.
This is SQL 2005 by the way.
This forum is for SQL Server 2005 as well.
August 24, 2009 at 3:40 am
Hi Old Hand 🙂
Sorry, I didn't make it clear. Yes, the actual server name is SOM-DB-ICCM but the entry in sys.sysservers is USDC-ICCMDBDEV, so when I try to configure log shipping it doesn't work.
I will see if I can find out if the server was indeed renamed at some point as that would definitely explain it.
Many thanks
Farren
August 24, 2009 at 3:44 am
sp_dropserver 'USDC-ICCMDBDEV'
go
sp_addserver 'SOM-DB-ICCM', local
go
Might work.
August 24, 2009 at 3:55 am
I'll have a look at that.
I'm a bit concerned as it's a live box in the US and I don't want to break anything 🙂
Regards
Farren
August 24, 2009 at 4:07 am
Yes...Be careful.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply