Hi,
Have installed TSM for MS SQL (vand i am now testing backup/recovery. I
have a test SQL server i can play with and this has 10 databases, i exclude
9 and only backup 1 at the moment, for testing.
In the DSM.OPT, i have
INCLUDE \...\database-name\...\* to backup just one of the ten
databases
EXCLUDE \...\* so that i can
exclude the other nine databases
I understood from the docs that if I backup a SQL database using FULL, then
a DIFFFULL backup (which i ran 5 minutes later) would only backup changes
since the last full backup.
Having ran a FULL backup, it dumped approx. 270mb of data from a single
database. When i ran the DIFFFULL backup, it dumped 57mb. The problem here
is that this is a test NT server, and no-one is accessing (therefore
updating) data, so why did the DIFFFULL dump 57mb when nothing has changed?
I read about a DIFFFULL % in the .cfg file, and that it defaulted to 20%. I
changed this to 10% but it made no difference.
My client server is NT, with SQL v7.0, TSM SQL client level 2.2.1
Anyone any ideas?
Jeff White
Senior Systems Programmer
CIS
Manchester
UK
*************************************************************************
This e-mail may contain confidential information or be privileged. It is
intended to be read and used only by the named recipient(s). If you are not the
intended recipient(s) please notify us immediately so that we can make
arrangements for its return: you should not disclose the contents of this
e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create
binding legal obligations between us and opinions expressed are those of the
individual author.
The CIS marketing group, which is regulated for Investment Business by the
Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for
life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 - for
unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL Telephone
0161-832-8686 Internet http://www.cis.co.uk E-mail cis AT cis.co DOT uk
CIS Deposit and Instant Access Savings Accounts are held with The Co-operative
Bank p.l.c., registered in England and Wales number 990937, P.O. Box 101, 1
Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder
Services Limited as agent of the Bank.
CIS is a member of the General Insurance Standards Council
CIS & the CIS logo (R) Co-operative Insurance Society Limited
********************************************************************************
|
