Post reply

TSM SQL Backup

  • March 6, 2012 at 10:26 pm

    #257093

    Hi Experts,

    We are in a project where we will be doing P2V for SQL cluster(VCS) and where SQL backup is implemented through TSM.

    1. Can anyone have documents the links on this migrations P2V where we have 2 node sql cluster configured on VCS?

    2. Can we restore TSM SQL backup on to new SQL Server box(New VM) without using TSM client or utilities.We want to use tsql backup/restore commands to restore these TSM backups. Is it feasible or not?

    Regards,

    Bipan

  • March 7, 2012 at 12:14 am

    #1455761

    So you have a physical cluster that is clustered using VCS and you want to virtualise it, is that correct?

    What version of SFW with HA (VCS) do you have installed?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 7, 2012 at 12:33 am

    #1455773

    Hi,

    You can't restore TSM backup without a client

  • March 7, 2012 at 12:48 am

    #1455775

    @Nchax Phoku

    Thanks for you reply.

    It further means TSM has its special mechanism of taking SQl backups and its not using any SQL native tsql backup commands for sql db backups.So in server we have to have TSM client which can only restore TSM sql backups.

    Please confirm.

    Any TSM links on this will help me a lot.

    Regards,

    Bipan

  • March 7, 2012 at 1:20 am

    #1455785

    Perry Whittle (3/7/2012)

    So you have a physical cluster that is clustered using VCS and you want to virtualise it, is that correct?

    What version of SFW with HA (VCS) do you have installed?

    ??????

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 7, 2012 at 1:55 am

    #1455799

    bipan (3/7/2012)

    @Nchax Phoku

    Thanks for you reply.

    It further means TSM has its special mechanism of taking SQl backups and its not using any SQL native tsql backup commands for sql db backups.So in server we have to have TSM client which can only restore TSM sql backups.

    Please confirm.

    Any TSM links on this will help me a lot.

    Regards,

    Bipan

    TSM (I guess you mean TDPSQL) uses the Virtual Backup Device Interface to "mount" a custom backup device implemented by the backup tool itself. However, the T-SQL command used is always BACKUP DATABASE.

    Long story short, you need to install the TDPSQL client.

    -- Gianluca Sartori

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply