UNSOLVED

telefonica1

updated

19 years ago

0

808

September 6th, 2007 08:00

backup failed

I have this problem running my backup

adp:MSSQL: 1 retry attempted
adp:MSSQL:: No full backups of this save set were found in the media database; performing a full backup
* adp:MSSQL: [2192] 09/06/07 10:54:18 The system cannot find the file specified.

* adp:MSSQL: .
* adp:MSSQL: [2192] 09/06/07 10:54:30 Microsoft SQL Server Provider error:
* adp:MSSQL: [2192] 09/06/07 10:54:30 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied..
* adp:MSSQL: [2192] 09/06/07 10:54:30
* adp:MSSQL: Cannot login to SQL Server null.
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    328

    0

    Posted September 6th, 2007 08:00

    It looks like SQL server was not found. Could be many things so I would suggest to start tests on client side first.
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    328

    0

    Posted September 6th, 2007 11:00

    Not sure about what test you did, but perhaps you forgot to use -s switch which should point towards NW server.
  • 328

    0

    Posted September 6th, 2007 11:00

    I ran a test from the server and said no NETWORKER server found , but if ping from the server to mi networker server he saw him also if i ping from my legato server he saw the server. In the host file of the server is configure the ip of the
    networker server adn in the host file of networker server is configure the client
    with all his alias.
  • wongj

    2 Posts

    328

    0

    Posted September 11th, 2007 20:00

    Hi Hrvoje,

    Have you checked the servers file if the client is pointing to the correct server?Windows = "networker install dir"/nsr/res/servers
    UNIX - /nsr/res/servers

    Maybe you can provide more information, e.g. what save command you ran?
    If it is a server initated backup, provide us with the line containing nsrsqlsv.

    Please also provide the Instance name, e.g. double click on SQL icon and note down the name server/instance name

    Please also check in the gui, remote user/password, if it is correct
  • IKP1

    198 Posts

    328

    0

    Posted September 13th, 2007 01:00

    Hi,

    Have you tried verifying that NetWorker can perform a file backup of this server - create a new NetWorker client for the same server which just backups up the temp directory with a browse and retention period of 1 day - no point in keeping the test longer than this.

    Then create a group on the server which just contains this newly created client, associate some storage to the group and then from the command line on the server run the savegrp command with -vvv (that is v v v *no spaces) and then see what is reported.

    This should at least give you conformation that the two servers are communicating within NetWorker - if this test fails then there is something stopping NetWorker data traffic between the two systems - is there a firewall involved, does the MSSQL server have SP2 installed - and have you disabled the internal software firewall that this service pack not only installs but enables. Also, there is a tech bulletin from EMC on configuring this.

    Hope this helps

    IKP

    Message was edited by:
    IKP
  • ble1

    6 Operator

    •

    14354 Posts

    •

    56186 Points

    328

    0

    Posted September 13th, 2007 01:00

    Hi Hrvoje,

    Hi Wong... It's not me who has the problem :)