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
|