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
|