Hi Leigh,
Thank you so much for your help. I will test tonight and see if my problem
is resolved.
Kind Regards
Adrian Compton
Leigh Reed
<[EMAIL PROTECTED]
> To
Sent by: "ADSM: ADSM-L@vm.marist.edu
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.edu> [ADSM-L] TDP for SQL Management
Classes
03/10/06 12:44
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.edu>
Adrian
You don't mention whether you are using the same nodename or different.
I see that you mention 3 opt files.
I think that the key to this is that you must use 3 different nodenames;
sql_daily, sql_monthly, sql_yearly.
The reason is that if you use the same nodename, the TDP rebinds all
previous backups to the MC you specify with the current full. Therefore
you won't achieve what you are looking for.
Also with the separate nodename approach, I find it easier to manage the
schedules, the occupancy and the tapes.
If you are looking to see if the backups are in the correct management
classes,
select * from backups where node_name='sqlservername' and
class_name='monthly'
If you want to get detail on specific dbs, you can use the hl_name
select * from backups where node_name='sqlservername' and
class_name='monthly' and hl_name='\master\'
Leigh
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Adrian Compton
Sent: 03 October 2006 09:09
To: ADSM-L@VM.MARIST.EDU
Subject: [SPAM: 4.000] [ADSM-L] TDP for SQL Management Classes
Hi,
I am having problems trying to setup the following and wonder if anyone
can
shed some light on this or have done so themselves.
I am backing up a number of SQL Databases. I am not worried about the
sizes, or whuich databases, but only require to do a full backup
including
any logs.
I have a daily schedule running and keep the versions for a week.
I want to also have a full backup/archive at month end (keep for 1 year)
and also a yearly(keep for 7 years) backups
I have setup 3 different sql.cmd files i.e Daily, monthly and yearly,
and
at the end of each of the include statement in the 3 opt files(also
daily,
monthly and yearly), put the relevant management classes.
Will this provide me with what I am looking to achieve. I am trying to
find
out where to look to see that the backups have gone to the correct
management classes.
Any assistance would be most appreciated.
Kind regards
Adrian Compton
