FYI...
The latest PTF available for TDP for SQL is 2.2.1.
You can get it here:
ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/tivoli-data-protection/ntsql/v221/
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL
a TSM Server command, not a TDP for Domino command.
This will also show which management class the objects are bound to.
(By the way, this view will show 2 TSM Server objects for each
database backup, one is a data object, the other a meta object.)
Thanks,
Del
--------
hy this is necessary.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
- Smile a lot: it costs nothing and is beyond price.
LUDE mail\user1.nsf.DATAMC1
INCLUDE mail\user1.nsf MC1
or
INCLUDE mail\user1.nsf*MC1
I hope this helps.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
- Smile a lot: it costs nothing and is beyond price.
activity log,
TSM API, and TDP for Domino logs, please call IBM support so that
some traces data can be gathered and examined.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
- Sm
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
- Smile a lot: it costs nothing and is beyond price.
Aaron,
Try this:
1. sp_dropserver 'FBINET'
2. sp_addserver 'FBINET', 'local'
3. Stop the SQL server service.
4. Restart the SQL Server service.
5. select @@servername
Also... take alook at Q article: Q303774
Thanks,
Del
-------
racle, David is correct, you will want
VERDELETED=0 and RETONLY=0.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
- Smile a lot: it costs nothing and is beyond price.
schedule? There are probably a number of different
ways to do this. Some of the customers I have talked to
set up a second NODENAME (like DOMSERV99.MONTHLY) and
run a full selective backup using that NODENAME.
Thanks,
Del
------------
Del Hoobler
I
.
You can set SQLBUFFERS to 0 to allow the SQL
server to decide what value to use.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
- Smile a lot: it costs nothing and is beyond price.
ass with copygroup settings that
match your needs. You can then bind all of the objects
for your monthly backups by having a different DSM.OPT file
and using the "INCLUDE * MC_NAME" option.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[E
backup using that NODENAME.
When doing that backup, they also make sure the
policy settings for those backups meet their needs.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Leave everything a little better than you found it.
- Sm
from the command-line client?
SQLDSMC /ADSMDELete:databasename,objectname[,sqlservername]
(By the way, I am sure you are aware... TDP for SQL version 1.1
went out of official service support on 1/26/2002.
See: http://www.tivoli.com/support/storage_mgr/tivolieoc.html)
Thanks,
Del
---
h data,
you may not have to run the full database backup as often.
Along the same lines, if your Domino server is very busy and
generates a lot of data, you may have to run full backups
more than once a week. It all depends on your data...
Thanks,
Del
---------
hers
that have fully implemented this in production
can help you out with their real-time strategies.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
NODENAME and
one options file, but it may be easier to manage with two.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
s
and not interfere with how long you can recover back to.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
ot doing any backup? On all other UNIX and
> Windows clients these two have numbers related to filesystem size.
>
Yahya,
These numbers are not used for TDP for Exchange.
Del Hoobler
t to know if it is possible to restore data to a different machine
while
> original one is still up and running.
>
Yahya,
No. This is not supported.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
crosoft docs that might help explain some of the
other issues to keep in mind.
http://www.microsoft.com/exchange/techinfo/deployment/2000/MailboxRecover.asp
http://www.microsoft.com/exchange/techinfo/deployment/2000/E2Krecovery.asp
Thanks,
Del
---
ll.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
nks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
> Is there a way to do a selective expire when using TDP MS/SQL Version 2?
Joel,
No. There is not. You must control everything
through TSM policies.
Thanks,
Del
----
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
be found at: http://www.redbooks.ibm.com/
The redbook publication number is: SG24-5247
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
change?
>
With Exchange 2000, you can back up storage groups simultaneously.
Exchange Exchange 5.5, you can back up the IS and the DIR
simultaneously, but that doesn't buy you very much, since the
DIR is typically small.
> 4) Any other pointers?
Thanks,
Del
--
no server is updated.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
DACCESS=GENERATE, you must code
the NODENAME in the DSM.OPT file.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
the password for an
automated execution.
For scheduled backups details, take a look
at Appendix A in the TDP for Lotus Domino
User's Guide for more details.
I hope this helps.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It
.log file might provide some information.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
> Do you think that TDP for Exchange can be affected by this error ?
> Can I replace API for TDP ?
>
> Regards
>Petr
Petr,
No. APAR IC31171 cannot happen with TDP for Exchange.
Thanks,
Del
------------
Del Hoobler
IBM Cor
ng down "-50" TCP/IP errors.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
environment?
Did you try specifying the /SQLSERVER option?
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
/tdp_ms.html#SQL
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
Robert,
Please call IBM support.
This is not enough information to
help diagnose the problem.
Support will probably need a trace.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't
rvice if you haven't
already done so.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
Gerald
Wichmann To: [EMAIL
confuses some pieces along the way.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
Storage
Agent User's Guide" for information on setting up a LAN Free
environment.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
ee.
I wasn't sure what the original question was asking.
I hope it is clear now. Thank you Paul.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
SQL 1.1.2
Installation and User's Guide, Appendix B, under section titled:
"Restoring an SQL Database from an Alternate SQL Server".
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
archive client.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
the database name with an "*".
For example:
EXCLUDE help\help5_*
There are more examples in Appendix E.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
longer backup elapsed
times due to the additional time for software compression.
But the bottom line to your question is that you
can run with COMRPESSION on or off. It will work
both ways.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
&
e above.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
then your only choice is to back up the entire database.
You might get TDP for Notes for R4 to work on an R5
Domino server, but it is not supported by IBM.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautif
luded with the PTF on the
FTP site above.
The USS (S/390) version is not available on the
FTP site but will be orderable through normal methods
some time in the near future.
Thanks,
Del
----
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"I
move it to
a directory without spaces and change your
"Objects" parameter to match.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
> Try specifying the short directory name in the
> "Objects" parameter. For example:
>
>Objects="C:\PROGRA~1\Tivoli\TSM\domino\dominc.cmd"
>
> Or you can do what Jan suggests and move it to
> a directory without spaces and change your
> "Objects" parameter to match.
>
Andy reminded me of ano
this, and need a fix,
they should contact Lotus support and work something out
with them in regards to an early fix for SPR #TBRT535LXZ.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
h TDP for SQL because
of the internal server error.
I recommend calling IBM/Tivoli support to find out what is going on.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
> Can TDP for Exchange encrypt Exchange Backups?
No. It can only compress them.
Thanks,
Del
rver.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
P for Domino 1.1.2.
There is an APAR IC27005 that is probably
the issue that you are seeing.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
and Recommendations".
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
up object is
marked inactive when you delete it through the
Exchange Application Client interface.
The above text was taken from the version 1
TDP for Exchange Installation and User's Guide.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PR
y force a
backup to the inactive state. At that point,
the policy settings of the copygroup take over.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
a while. I suggest that when this occurs, you look
at the SQL Server log to see what the SQL Server thinks is going on.
Other than that, you may want to open a PMR so that Level 2
can gather trace information to find out where the hang really is.
Thanks,
Del
----------
.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
000.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
; that has no EXCLUDE statements
and one that is used for the "DIFFERENTIAL backups"
that EXCLUDEs the master database.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
g files (.LOG).
You should exclude those files from backup
when setting up your standard BA client for
backing up files since TDP for Exchange
handles those files for you.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It
the files involved with Exchange systems.
http://www.microsoft.com/Exchange/techinfo/administration/55/BackupRestore.asp
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Life is short but sweet for certain..."-- Dave
n. In addition,
version 2 "officially" supports SQL 2000. (TDP for SQL version 1
does not support SQL 2000.)
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Life is short but sweet for certain..."-- Dave
...
>
> Mark
Mark,
This is only true for TDP for Exchange version 1.
TDP for Exchange version 2 uses TSM full policy management
so you can set up your management classes to control
all of this through policy settings and INCLUDE lists.
Thanks,
Del
---
lservername
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Life is short but sweet for certain..."-- Dave
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Life is short but sweet for certain..."-- Dave
1.1 does not support
SQL 2000. You must have TDP for SQL 2.2 in order
to get official support for SQL 2000.
TDP for SQL 1.1 supports SQL 6.5 and SQL 7.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Life is short but sweet for certain..."-- Dave
are running TDP for SQL version 1.1 then you
must upgrade to version 2.2 if you want to
support this configuration.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Life is short but sweet for certain..."-- Dave
se the short name for the path.)
I hope this helps.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Life is short but sweet for certain..."-- Dave
group is stored within one TSM Server filespace.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
this continues, even after a machine reboot, I would contact
IBM support so that traces can be gathered to help diagnose
what the problem is.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
son does not
appear when this same command is run manually.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
t database with the backup tool shipped
with SQL server. Does it fail also?
If you still cannot get things to work, please
call IBM support.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
a disaster, where the SQL Server application is
corrupted, you can re-install SQL Server, and then restore your
databases via TDP for SQL.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
client
is backing up the registry. I hope this helps.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
t be a need to. If you have changed the name of
a storage group or server name, you can always use the
DELETE FILESPACE command to delete all data under a
specific filespace if that's what you really want to do.
Thanks,
Del
--------
Del Hoobler
elp diagnose
what is going wrong with the TSM query.
Thanks,
Del
----
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
e TDP SQL log report as a problem?
If it continues to happen, I would recommend calling IBM Service.
A TDP and API trace would help diagose the problem.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Lif
. (Like: DIR >> file.out).
There isn't anything available for those. You will have to devise
your own scheme to prune those.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
sn't seem right here...
Even if the meta data is on tape... it should work...
It just may take a little while for the meta data to be
retrieved and filled in on those screens... but it should work.
I would open a call with IBM support.
Thanks,
Del
--------
SQL 2000 it doesn't matter; just schedule as needed
for the desired restore criteria.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
n recovering from a full Domino transaction log.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
no longer
uses /ADSMAUTODELETE since version 2.2.0 utilizes full
policy management and your policy definitions handle
the deletions for you.
Thanks,
Del
------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short b
on, please call support for assistance.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
is a cascaded problem caused by
APAR IC31617. Once the fixtest is applied, you should
not experience IC31372.
Bottom line: Apply TSM API 4.2.1.20 and retry the backup.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebra
9348 dealt with the old version 1 technique for running backups.
The same problem reported in APAR IC29348 should not be occurring
with version 2.2. Please open a problem record with IBM support
so proper diagnosis can be done.
Thanks,
Del
------------
Del
No. This is not possible.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
s you have for migration.
**
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
set up COMMAND type schedules that
call xxx.cmd files that run the desired backups.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
ange installation directory.
One is called excfull.smp. The other one is excincr.smp
These should get you started.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"Celebrate we will. Life is short but sweet for certain..." -- Dave
o the SQLFULL.CMD and you did not
put the proper quotes around it. If this is the case
look back a the archives of this list and you will
a solution to that problem.
Thanks,
Del
----
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Remember that the
enough to fulfill
the multiple stripe restore request.
If you cannot figure out what the problem is,
please calll IBM support.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Remember that the best job security is
doing a job well
correct.
If you continue to have problems, please call IBM support.
Deleted objects are serious business and indicate
that something else is going wrong with your TSM Server.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Remember
Ed,
I just obtained this with anonymous:
ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/tivoli-data-protection/ntsql/v515/nt/
Thanks,
Del
===
> Anyone knows the link for the TDP for MS SQL version 5.1.5.0?
> I've
getting in the way,
please call IBM support. A trace of the problem recreation
may help determine what is going on.
Thanks,
Del
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Remember that the best job security is
doing a job well and doing it
n a Try and Buy
license through your IBM representative.
Thanks,
Del
--------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Remember that the best job security is
doing a job well and doing it cheerfully.
=
anks,
Del
----
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
- Remember that the best job security is
doing a job well and doing it cheerfully.
===
> 03/05/2003 08:24:48 Backup
301 - 400 of 1716 matches
Mail list logo