ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/22/2009
10:21:12 PM:
[image removed]
Re: TDP Sql backups of mirror databases
Bill Boyer
to:
ADSM-L
01/22/2009 10:21 PM
Sent by:
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
Please respond to ADSM: Dist
SQLServer 2005 on Windows2003.
TSM Server 5.5.0.3 on Windows2003.
TDP Sql 5.5.0.0
There are 3 databases on this SQLServer that are mirrors from another (not a
cluster) and I have them specified in the DSM.OPT to be excluded. During the
BACKUP * FULL I receive errors about the status of the
on 01/22/2009
04:02:41 PM:
[image removed]
TDP Sql backups of mirror databases
Bill Boyer
to:
ADSM-L
01/22/2009 04:03 PM
Sent by:
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
Please respond to ADSM: Dist Stor Manager
SQLServer 2005 on Windows2003.
TSM Server 5.5.0.3
. The destination is just the excuse. - ??
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Del
Hoobler
Sent: Thursday, January 22, 2009 8:00 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDP Sql backups of mirror databases
Hi Bill,
Take a look
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP SQL Backups
Bruce,
In that case... you simply need to set the Log On As account
for the scheduler service to the Windows userid that has been
given permission on the SQL Server. Userid and password
on the command-line are only meaningful
Bruce,
Data Protection for SQL requires SYSADMIN role for the ID that
runs the backups and restores. This is because Data Protection for SQL
uses the Microsoft recommended SQL Server Virtual Device Interface (VDI)
API
for performing backup and restore of the SQL Server databases.
In order to
On some of my SQL servers rights have been taken away from the local system
account to SQL. In the documentation I found that I can add the username
password to a user that has rights to backup SQL to the command file to run
the backup. The problem with this is that it is in clear text so
Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Kamp, Bruce
Sent: Wednesday, April 25, 2007 9:05 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] TDP SQL Backups
On some of my SQL servers rights have been taken away from the local system
account to SQL. In the documentation I found that I can add
Bruce,
If you want to use SQL Server authentication. i.e.
/SQLAUTHentication=SQLuserid
Did you try to use the GUI--- Utilities --- SQL Server Login Settings
to set your SQL Server login id and password?
Then, stop the DP/SQL GUI... and try this command:
TDPSQLC QUERY SQL
]
Phone: (954) 276-4097
Fax: (954) 276-5381
---
-Original Message-
From: Del Hoobler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 25, 2007 12:37 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP SQL Backups
Bruce,
If you want
.
=
Sent: Wednesday, April 25, 2007 12:37 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] TDP SQL Backups
Bruce,
If you want to use SQL Server authentication. i.e.
/SQLAUTHentication=SQLuserid
Did you try to use the GUI--- Utilities --- SQL Server Login Settings
I goofed and forgot to set DELETE BACKUPS = YES on a TDP SQL client (now
corrected)
So now, there are 1/2 Terrabyte of garbage SQL backups.
How do I get rid of them ?
I was hoping that EXPIRE INVENTORY would clear them out since I corrected
the setting, but it has not.
An: [EMAIL PROTECTED]
Betreff: Flushing out old TDP SQL backups
I goofed and forgot to set DELETE BACKUPS = YES on a TDP SQL client (now
corrected)
So now, there are 1/2 Terrabyte of garbage SQL backups.
How do I get rid of them ?
I was hoping that EXPIRE INVENTORY would clear them out since I
by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
01/20/2004 09:05 AM
Please respond to ADSM: Dist Stor Manager
To: [EMAIL PROTECTED]
cc:
Subject:AW: Flushing out old TDP SQL backups
for the TDP Oracle it has an executable namend TDPSYNC with the Parm
SYNCDB
Zoltan,
Do you mean the TSM Server setting on the NODENAME
called BACKDELETE=YES? Even it is set to NO,
it will not keep your good backups from expiring.
The BACKDELETE=YES setting is only important for
cleaning up backups when there was a failure during
a backup and there are temporary objects
answers !
Thanks for the help.
Del Hoobler [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
01/20/2004 09:49 AM
Please respond to ADSM: Dist Stor Manager
To: [EMAIL PROTECTED]
cc:
Subject:Re: Flushing out old TDP SQL backups
Zoltan
16 matches
Mail list logo