Hello,

Yesterday I ran into my first SQL / ADSM problem.  Maybe someone out there
can help.

The scenario is a SQL 7.0 Server running on NT4 SP4 with ADSM SQL Connect
Agent 1.1.1 reporting to an ADSM Server 3.1.2.13 on NT4 SP3.

What I tried to do is restore a FULL backup of the "FROM-DB" into the
"TO-DB", via the GUI.  (Right Clicking on the FULL backup and selecting
Restore into....)  These are about 4.1GB in size.  The "TO-DB" is empty, I
just created it to receive the "FROM-DB."

The error below is what I received.  If I had to guess, I would say this is
a SQL problem, and not so much ADSM, but I can't tell.  I was using a SQL
account for the SQL Agent that is dbo for both databases.

Any ideas?


03/24/1999 14:47:03,Restored - name: TO-DB, type: DB, size: 4087150018,
actual bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: (SQLSERVER), ADSM
server: dsm, SQL status: DB-LIB message: The file
'I:\FROM-DB\FROM-DB_Data.MDF' cannot be used by RESTORE. Consider using the
WITH MOVE option to identify a valid location for the file., ADSM status:
ACO3028E -- Error: SQL server errors encountered.


Thanks,

Nathan J. Norrgard
PC Systems Administrator
Liberty Bank
860.638.2938
NNorrgard AT Liberty-Bank DOT com