1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Questions/HELP + TDP for SQL 6.3

Discussion in 'Microsoft SQL Server' started by Gipsy, Aug 20, 2012.

  1. Gipsy

    Gipsy New Member

    Joined:
    Aug 20, 2012
    Messages:
    3
    Likes Received:
    0
    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
     
  2.  

Share This Page