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 [EMAIL PROTECTED] 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 ********************************************************************************