MSSQL backup sequence
2003-07-09 12:12:43
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>
|
- MSSQL backup sequence,
Paul van Dongen <=
|
|
|