ADSM-L

Re: [ADSM-L] Portable restore from TDP for Databases (SQL) ?

2011-03-30 10:54:21
Subject: Re: [ADSM-L] Portable restore from TDP for Databases (SQL) ?
From: Shawn Drew <shawn.drew AT AMERICAS.BNPPARIBAS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 30 Mar 2011 10:41:56 -0400
>From what I understand, you want to send a copy of your DB over to a
vendor before performing a modification.
Instead of using TSM, why not use the internal DB processes for doing
this?  (BAK files for MS SQL)
Continue using TDP for your internal backups but use the disk-based BAK
files for these one-off requests.

Regards,
Shawn
________________________________________________
Shawn Drew





Internet
RickAdamson AT WINN-DIXIE DOT COM

Sent by: ADSM-L AT VM.MARIST DOT EDU
03/30/2011 08:41 AM
Please respond to
ADSM-L AT VM.MARIST DOT EDU


To
ADSM-L
cc

Subject
[ADSM-L] Portable restore from TDP for Databases (SQL) ?






We have a remote vendor who sends updates to a SQL db that lives on one
of our SQL servers. From time-to-time the updates are determined
undesirable and before performing a restore in production  we want to be
able to send them a portable copy so they can determine the root cause
of the problem before moving forward. I have had this situation come up
before and scoured over the TDP documentation and found no clear
definition of how to complete the task.



Is there a way to perform what I will call a portable "flat file"
restore of SQL databases from TSM without it affecting the production
copy that is live on the SQL server?

How do you handle these requests?



All feedback appreciated....TIA



Rick Adamson

Jacksonville, FL



This message and any attachments (the "message") is intended solely for
the addressees and is confidential. If you receive this message in error,
please delete it and immediately notify the sender. Any use not in accord
with its purpose, any dissemination or disclosure, either whole or partial,
is prohibited except formal approval. The internet can not guarantee the
integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will)
not therefore be liable for the message if modified. Please note that certain
functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc.