Hello colleagues,

I evaluate currently TSM TDP for SQL (v. 6.3). The "normal" functions, such as: backup, restore, restore point in time and so work very fine.

Now I want to go a step further.

-----------------------------------------

Consider the following scenario:

The database "AdventureWorks" is displayed in the Management Studio as 'corrupt', or you can no longer access them.
Prerequisite: The database file (*.mdf) is corrupt, the log file (*.ldf) is still ok.

-----------------------------------------

Currently I'm doing the backup of the databases for the management studio (including transaction logs).

-----------------------------------------

About the Management Studio I would do the following:

1. A TAIL-Backup of the Log file (*.ldf)
BACKUP LOG AdventureWorks TO DISK='F:\*.trn' WITH NORECOVERY, NO_TRUNCATE

2. Restore the database with a FULL BACKUP and with all the associated transaction logs (Option: NORECOVERY)

3. Restore the TAIL-Backup (Option: WITH_RECOVERY)

Database is back online and should work fine (without data loss).

-----------------------------------------

Is that even possible in TSM? If so, how do I do that?

Can you help me?

Best regards,

Gipsy