Re: SQL Logs and Backup conflict
2006-01-10 15:45:47
clarification question.
are you using a same node name for both TDP agent and regular client?
Or you are not using any TDP and straight forward regular node name?
Sung Y. Lee
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/09/2006
09:15:08 AM:
> We are looking for a creative solution (or answer) to a long outstanding
> "issue" when it comes to SQL TDP backups.
>
> We have a major M$-SQL shared server.
>
> There is an HOURLY schedule to dump the transaction logs.
>
> When the daily backups kick off, the hourly transaction log backups then
> proceed to fail, causing constant annoying "schedule has failed"
messages,
> until the DB backups finish.
>
> How do other folks handle this kind of conflict ? Are we missing some
TDP
> backup option ?
>
> My prefered solution would be to have TSM scheduling be more flexible,
> e.g. only run this schedule between 10am and 10pm.
>
> Your thoughts ?
|
|
|