Are the files that still show DEFAULT management class active or inactive? I should clarify what I said earlier: the rule about rebinding applies only if the files still exist on file system. Files with no active versions are not rebound. Also, did you run an incremental against the file system (or at least the SQLBACKUPS directory and its subdirectories)? Or did you just select certain files?
I could probably give a more specific answer if you could provide more specific info such as file names you are backing up, output from incremental command, output from query backup command, etc. For example, output from: dir d:\sqlbackups dsmc i d:\sqlbackup\ dsmc q ba d:\sqlbackups\ (If there are subdirectories of the sqlbackups directory, then use /s option with the dir command and -su=y option with the dsmc commands.) Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Mike Bantz <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 03/02/2004 12:44 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Re: Problems with binding mgt class to file I believe that's the fix - ran an incr right after I changed that to a single * and it applied the new DBDUMPS mgt class. But from your email, it would seem that "all existing backup versions will be rebound to the DBDUMPS management class". However, I just ran that incr, and opening up the BA GUI shows that all previous dumps are bound to the DEFAULT mgt class. Mostly, I just don't want those 30+ copies of a 15gig database sitting out there on tape taking up room if they don't need to be... Thanks! Mike Bantz -----Original Message----- From: Andrew Raibeck [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 10:38 AM To: [EMAIL PROTECTED] Subject: Re: Problems with binding mgt class to file A few things: 1) In your INCLUDE statement, change the *.* to a single asterisk, *, i.e. include d:\sqlbackups\...\* dbdumps This ensures that any files not having an extension (i.e. file name"myfile" versus "myfile.txt") are also bound to the management class. In general, unless you want to distinguish between files with and without extensions, using the single asterisk is recommended. 2) Note that directories will not necessarily be bound to the DBDUMPS management class. Rather, they are bound to the management class with the highest RETONLY setting, unless you override this rule with the DIRMC option. Search http://search.adsm.org for past related discussion. 3) If indeed your database files have extensions in their file names and you are noticing files, not directories being bound to a management class other than DBDUMPS, it is almost certainly a problem related to your include/exclude list. It would help to see the output from the command dsmc query inclexcl (make sure you are using the same options file and node name as the backups when you run this command). Once the INCLUDE issues are straightened out, all existing backup versions will be rebound to the DBDUMPS management class. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Mike Bantz <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 03/02/2004 10:15 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Problems with binding mgt class to file I've got some database dumps that we do every night (full backups) that I want to bind to a specific management class called DBDUMPS. In the dsm.opt file, I've got the following: include "d:\SQLBackups\...\*.*" DBDUMPS Yet when I look at this in the baclient GUI, all of those files available for recovery are using the default management class. Something I'm missing here? Also, once I do manage to get those to the right management class, how do I rebind any files to apply to the management class? TIA, Mike Bantz
