Bo,
Add ",sqlservername" to the /restorefull command.
"sqlservername" must match the name of the SQL server
that performed the backup. For example, if the SQL server
that performed the backup was "SQLSRV12", it would be:
sqldsmc /restorefull:Northwind,10211999132606.db,SQLSRV12
/sqluser:sa /sqlpwd:sapasswd
(Above command split into multiple lines just for this note.)
Del Hoobler
hoobler AT us.ibm DOT com
> 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
|