ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
> > Behalf Of Del Hoobler
> > Sent: Saturday, 4 August 2007 2:37 AM
> > To: ADSM-L@VM.MARIST.EDU
> > Subject: Re: [ADSM-L] TDP for SQL question
> >
> > Paul,
> >
> > Typically... I see that peop
L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] TDP for SQL question
>
> Paul,
>
> Typically... I see that people will name their node
> the same as their primary SQL node with an extension.
> Something like:
> Primary: SQLSRV23_SQL
> Archive: SQLSRV23_SQL_ARCH
Paul,
Typically... I see that people will name their node
the same as their primary SQL node with an extension.
Something like:
Primary: SQLSRV23_SQL
Archive: SQLSRV23_SQL_ARCH
And they will have a separate DSM.OPT file, something like
DSMARCH.OPT that has the archive nodenam
On 03/08/2007, at 2:53 PM, Paul Dudley wrote:
I have been told that if I want to create an "archive" backup of an
SQL
database via TDP for SQL, then I should create a separate node name in
TSM (such as "SQL_Archive") and then backup using that node name
once a
month (for example) and make sure t
I have been told that if I want to create an "archive" backup of an SQL
database via TDP for SQL, then I should create a separate node name in
TSM (such as "SQL_Archive") and then backup using that node name once a
month (for example) and make sure to bind those backups to a management
class that h
are re-investigating.
Thanks!!!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-Original Message-
From: Del Hoobler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 21:02
To: [EMAIL PROTECTED]
Subject: Re: TDP for SQL question
Eric,
I would have them check again to make
Eric,
I would have them check again to make sure they
are using the NODENAME they think they are using.
Have them check their DP for SQL logs files as well.
Also, check the TSM Server activity log to see
what messages are being logged for that NODENAME.
DP for SQL will log ending statistics that
s
Hi *SM-ers!
I have got two TDP for SQL 2.2 clients. On one of them I see two filespaces:
Nodename\meta\
Nodename\data\
Both filespaces have a backup date <1, so that seems ok. The other node
however has both filespaces listed with a backup date of 31 days ago. So I
was thinking that the bac
> Now the question, can we tell the TDP client to do a restore of the
> production database but then redirect it to another server running SQL?
We
> have a spare server that has plenty of space that can be used for this.
If you are using TDP for SQL 1.1.2, refer to the TDP for SQL 1.1.2
Installat
We have a situation where we are trying setup a test SQL database on
a server.
The server (WinNT4 w/TSM client 3.7.2 and SQL client 1.1.2 and
MS-SQL 6.5) itself is cramped for space and we need to make a copy of the
database so that we can do some testing and still keep the product
r Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: TDP for SQL Question
Yes, by default that is the way it is done. After you install TDP on the
client, look in the ..Tivoli/TSM/Mssql directory. The file sqlfull.smp is
designed to be copied to sqlfull.cmd. You need
urtis" To: [EMAIL PROTECTED]
Subject: TDP for SQL Question
Sent by:
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
IST.EDU>
gt;
We are looking into starting to use TDP for SQL. Question from our DBA's:
When configuring the SQL Server backups is it possible to configure a backup
that will backup ALL the SQL Server databases (master, msdb, and user
created) with one command such that if additional databases are
We are looking into starting to use TDP for SQL. Question from our DBA's:
When configuring the SQL Server backups is it possible to configure a backup
that will backup ALL the SQL Server databases (master, msdb, and user
created) with one command such that if additional databases are add
14 matches
Mail list logo
