ADSM-L

SQL restore from another node......

1999-10-26 04:20:51
Subject: SQL restore from another node......
From: Bo Nielsen <Bo_Nielsen AT FDB DOT DK>
Date: Tue, 26 Oct 1999 10:20:51 +0200
I will appreciate some help.

We have a SQL fall-back server,
and my DBA want, when the batch SQL-backup is finish,
then I do a batch restore on the fall-back SQL server,
but I get follow message from dsmsched.log:

COMMAND LINE : sqldsmc /restorefull:tempdb,10211999132606.db /sqluser:
/sqlpwd:
10/22/1999 13:40:50,ANS1088E (RC124)  File space does not exist
10/22/1999 13:40:50,Restored - name: tempdb, type: DB, size: 0, actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: FDB050, ADSM server: dsm,
SQL status: Completed, ADSM status: ACO3027E -- Error: ADSM server errors
encountered.

The dsm.opt file on the Primary SQL server looks like this:

NODename          fdb048_SQL
PASSWORD xxxxxx
SCHEDMODE             Prompted

The dsm.opt file on the fall-back server looks like this:

NODename          fdb048_SQL
PASSWORD xxxxxx

The SQL-server is vers 7.0.
The ADSM server is vers. 3.1.2.20.
The ADSM ConnectAgent is 1.1.1A


Bo Nielsen

FDB data                                    Phone: +45 4386 4671
Roskildevej 65                             Fax:     +45 4386 4990
DK-2620 Albertslund                    E-mail: bo_nielsen AT fdb DOT dk
Denmark
<Prev in Thread] Current Thread [Next in Thread>