Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

TSM SQL Backup Expand / Collapse
Author
Message
Posted Tuesday, March 6, 2012 10:26 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 7, 2014 5:05 PM
Points: 52, Visits: 403
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
Post #1262692
Posted Wednesday, March 7, 2012 12:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 6,304, Visits: 13,601
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"
Post #1262732
Posted Wednesday, March 7, 2012 12:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 3:26 AM
Points: 39, Visits: 487
Hi,

You can't restore TSM backup without a client
Post #1262744
Posted Wednesday, March 7, 2012 12:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 7, 2014 5:05 PM
Points: 52, Visits: 403
@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
Post #1262746
Posted Wednesday, March 7, 2012 1:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 6,304, Visits: 13,601
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"
Post #1262757
Posted Wednesday, March 7, 2012 1:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:18 AM
Points: 5,018, Visits: 10,535
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

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1262771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse