Arunav Mandal wrote:
>>> Tried it again bacula marked it as Error.
>>
>> Did you read the message from Phil from 13.09.2005 19:37?
>>
> Yes but how to do that?
Try this -- in the console:
[you type:]
sql
[bacula responds:]
Using default Catalog name=MyCatalog DB=bacula
Entering SQL query mode.
Terminate each query with a semicolon.
Terminate query mode with a blank line.
Enter SQL query:
[you type:]
update Media set VolFiles = 303, VolStatus = "Append" where VolumeName =
"your_volume";
[This query produces no output]
[you type:]
select VolumeName, VolFiles, VolStatus from Media;
[Bacula displays something like:]
+-------------------+----------+-----------+
| VolumeName | VolFiles | VolStatus |
+-------------------+----------+-----------+
| VXA-V17-Full-0001 | 0 | Recycle |
| VXA-V17-Full-0002 | 31 | Purged |
| VXA-V17-Full-0003 | 10 | Purged |
| VXA-V17-Inc-0001 | 0 | Recycle |
| VXA-V17-Inc-0002 | 37 | Append |
| VXA-V17-Full-0004 | 32 | Full |
| VXA-V17-Full-0005 | 28 | Full |
| VXA-V17-Full-0006 | 38 | Full |
| VXA-V17-Full-0007 | 35 | Append |
+-------------------+----------+-----------+
Check it's correct, and just hit Enter to exit SQL query mode.
--
Phil Stracchino [EMAIL PROTECTED]
Renaissance Man, Unix generalist, Perl hacker
Mobile: 603-216-7037 Landline: 603-886-3518
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download it for free - -and be entered to win a 42" plasma tv or your very
own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
