Post reply

SQL SERVER 2005 LOG SHIPPING PROBLEM ...

  • July 23, 2007 at 2:44 am

    #117784

    Hello DBA's

    I have this following configuration of server

    Windows Server Name : ABC-CDEFGHI-JKLM

    But when I check the SQL Server 2005 Logs: 

     .

     .

     Local computer is ABC-CDEFGHI-JKL running Windows NT 5.2 (3790) Service Pack 2

     .

     .

     

    I am trying to configure log shipping on this server but this give me an error like this:

    SQL SERVER Management Studio could not save the configuration of 'ABC-CDEFGHI-JKL' as primary

    .....

    The specified @servername('ABC-CDEFGHI-JKLM') does not exist(Microsoft SQL Server Error: 14262)

    *If you see the Windows Server Name and SQL Server name they are different, SQL SERVER Name is short of

    one character .. Windows Server Name has 16 character and SQL Server name is 15 character.

    Any input is much appreciated - I need help to configure my log shipping.

    Thank you!

    Jeboy!

  • July 23, 2007 at 2:56 am

    #721462

    Hi

    i think the sql server name (instance name)

    may be 'ABC-CDEFGHI-JKL'. u must have installed default instance of sql server.

    execute this and check the server name

    select @@Servername

    "Keep Trying"

  • July 23, 2007 at 3:22 am

    #721468

    If its a default instance then it should be same as server name but here its one letter short. Anyways just do a select @@servername and check. Also do a select serverproperty('ServerName') and chek if it dispalys th server name rightly.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 23, 2007 at 4:07 am

    #721473

    Guys..

    I have executed the following command and I got different output..

    select serverproperty('ServerName')

    ABC-CDEFGHI-JKL

    SELECT @@SERVERNAME

    ABC-CDEFGHI-JKLM

    Strange. ..

    Please advice.

    Thank you!

    Jeboy!

     

  • July 23, 2007 at 5:01 am

    #721484

    So what does your windows hostname command return. It should return ABC-CDEFGHI-JKLM. If not then the problem starts there itself else its somewhere in sql data engine.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 23, 2007 at 5:06 am

    #721486

    Yes found the answer. The NetBIOS name for any computer can be only 15 bytes and in your case it was 16 bytes and the last character has been truncated. And my previous post should now result you with ABC-CDEFGHI-JKL as the server name will be truncated and stored. Hope this post was helpful to you and provided the answer.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply