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: Wednesday, December 10, 2014 11:48 AM
Points: 53, Visits: 413
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 @ 7:19 AM
Points: 6,741, Visits: 14,375
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: Monday, December 15, 2014 4:56 AM
Points: 39, Visits: 517
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: Wednesday, December 10, 2014 11:48 AM
Points: 53, Visits: 413
@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 @ 7:19 AM
Points: 6,741, Visits: 14,375
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:22 AM
Points: 4,654, Visits: 11,115
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

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Post #1262771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse