ADSM-L

SQL Connect Agent 1.1.1A

1999-04-08 13:29:42
Subject: SQL Connect Agent 1.1.1A
From: "Norrgard, Nathan" <NNorrgard AT LIBERTY-BANK DOT COM>
Date: Thu, 8 Apr 1999 13:29:42 -0400
I recently applied the latest fixtest to my SQL servers.  Obviously, I was
excited about the new autodelete feature.  I was experimenting this morning
with configuring a scheduled deletion of undesirable database backups.  The
command was this:

sqldsmc /adsmautodelete:* /ifolder:1 /logfile:autodelete.log

This was the result of that log file:


04/08/1999 13:04:51,COMMAND LINE : sqldsmc /adsmautodelete:* /ifolder:1
/logfile:c:\adsm\site\logs\autodelete.log
04/08/1999 13:04:52,Logging on to the ADSM server...

04/08/1999 13:04:52,ANS1088E (RC124)  File space does not exist
04/08/1999 13:04:52,Database : CommercialR..., Object Name :
04011999185124.db, status : ACO3019E -- An error was encountered.
04/08/1999 13:04:52,ANS1088E (RC124)  File space does not exist
04/08/1999 13:04:53,Results: 0 backup object(s) of 1 examined were deleted.
04/08/1999 13:04:53,ANS1088E (RC124)  File space does not exist


Now, when I tried selecting only one database, rather than all, it worked
just fine.  The command was:

sqldsmc /adsmautodelete:model /ifolder:1 /logfile:autodelete.log
(Obviously, selecting the MODEL database to be deleted, all backups older
than today.)

The log was this:

04/08/1999
13:04:06,===================================================================
====
04/08/1999 13:04:06,COMMAND LINE : sqldsmc /adsmautodelete:model /ifolder:1
/logfile:c:\adsm\site\logs\autodelete.log
04/08/1999 13:04:06,Logging on to the ADSM server...

04/08/1999 13:04:07,Database : model, Object Name : 04011999185204.db,
status : Completed
04/08/1999 13:04:07,Database : model, Object Name : 04021999185154.db,
status : Completed
04/08/1999 13:04:07,Database : model, Object Name : 04051999192650.db,
status : Completed
04/08/1999 13:04:08,Database : model, Object Name : 04061999185200.db,
status : Completed
04/08/1999 13:04:08,Results: 4 backup object(s) of 6 examined were deleted.

Any ideas?

I am running SQL Connect Agent 1.1.1A on an NT4 SP3 server with SQL6.5 SP4
to an ADSM server 3.1.2.20 on NT4 SP3.

I haven't tried the autodelete feature on my Exchange server yet....

Thanks!

Nathan J. Norrgard
PC Systems Administrator
Liberty Bank
860.638.2938
NNorrgard AT Liberty-Bank DOT com
<Prev in Thread] Current Thread [Next in Thread>