ADSM-L

MSSQL backup sequence

2003-07-09 12:12:43
Subject: MSSQL backup sequence
From: Paul van Dongen <paul AT VANGUARD-IT.COM DOT BR>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 9 Jul 2003 13:10:48 -0300
Hello all, 

     I am busy doing some SQL Server backups, and my goal is:

- Do full backups on sundays.
- Differential backups on the other days.
- Be able to restore any of the backups in a 30 days window

I defined a management class specifying Verexists=30 and RetExtra=30 and
made some tests:

1. When I run the full backup, I get an active version (OK)
2. When I run the differentials (3 of them), I get one active version
and two inactive versions. Still OK
3. When I run another full backup, what happens: I see (in the TSM foor
SQL restore GUI) two full backups (one active and one inactive), but I
see only the last differential made (marked inactive).

Looking in the BACKUPS table, I see that the two other differentials
still exist in the database, but with their inactivate date set as
follows:

     NODE_NAME: TRIUNFO-SQL
 FILESPACE_NAME: TRIUNFO\data\0001
   FILESPACE_ID: 6
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \model\
        LL_NAME: difffull
      OBJECT_ID: 35879
    BACKUP_DATE: 2003-07-09 12:02:02.000000
DEACTIVATE_DATE: 1900-01-01 00:00:00.000000
          OWNER: 
     CLASS_NAME: MC-SQL


And I can't see them in the restore window. Any hints?

-- 
Paul Gondim van Dongen
Engenheiro de Sistemas
MCSE
IBM Tivoli Storage Manager Certified Consultant
VANguard - Value Added Network guardians
http://www.vanguard-it.com.br
Fone: 55 81 3225-0353

<Prev in Thread] Current Thread [Next in Thread>