Hi Joachim
Have you considered using a Tivoli Data Protection agent., to be able to
handle online backups?
If not, with MS SQL, you can use dump methods to dump the database to a
different location, and then use the TSM backup/restore klient to backup
that file. If you talk to your SQL admin, he will probably know what you're
meaning with a dump. I don't remeber the exact SQL statement, but it is
something like this:
DUMP DATABASE "DATABASENAME" C:\DUMP\"DATABASENAME".DMP
But, I recommend taking a look at Tivoli Data Protection for MS SQL. You
will probably not be able to run the latest version, as it only support
version 7.0 and 2000, but you should be able to run version 1.1.
Best Regards
Daniel Sparrman
-----------------------------------
Daniel Sparrman
Daniel Sparrman
Exist i Stockholm AB
Bergkällavägen 31D
192 79 SOLLENTUNA
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51
"Stumpf, Joachim"
<joachim.stumpf@D To: ADSM-L AT VM.MARIST
DOT EDU
ATEV.DE> cc:
Sent by: "ADSM: Subject: Re: question:
db-backup
Dist Stor
Manager"
<[email protected]
.EDU>
2002-03-20 13:17
Please respond to
"ADSM: Dist Stor
Manager"
Hi again,
the application is a MS-SQL 6.0 db-server.
At 23:00h started the TSM-backup.
And at 00:30h a person from the db-group tried a update to the db, but the
backup was running.
In this case the Node had a big problem with its RAM (RAM ran full) and our
NT-Admin wanted to know if this was caused by the update of the db during a
backup.
Our Nodes usually have a 100Mbit network card and the server is an OS/390
TSM-Server;but we have lots of Nodes, so the transfer rate is very slow...
but this is something else we had analized last summer ;)
--
regards / Mit freundlichen Gruessen
regards / Mit freundlichen Gruessen
Joachim Stumpf
Datev eG
Nuremberg - Germany
"robert" <robert AT plcs DOT nl> (Mittwoch, 20. März 2002, 13:58:15, CET):
> Hi Joachim,
>
> What kind of network are you using now? Is there something wrong with
> your NIC. With Tokenring you should at least get around 4 Gigabyte/Hour.
> Maybe consider compression on you ba client.
>
> Robert.
>
>
> > Hi again Joachim,
> > Yes you will receive 'file in use' message. What kind of database are
> you
> > talking about and is it a online backup you are doing? You can try to
> change
> > mode on the database during backup (but I´m not sure it will help) or
> make a
> > database export and backup the exported copy.
> >
> > //Henrik
> >
> >
> >
> > |--------+------------------------->
> > | | "Stumpf, |
> > | | Joachim" |
> > | | <joachim.stumpf|
> > | | @DATEV.DE> |
> > | | Sent by: "ADSM:|
> > | | Dist Stor |
> > | | Manager" |
> > | | <ADSM-L AT VM DOT MARI|
> > | | ST.EDU> |
> > | | |
> > | | |
> > | | 2002-03-20 |
> > | | 11:30 |
> > | | Please respond |
> > | | to "ADSM: Dist |
> > | | Stor Manager" |
> > | | |
> > |--------+------------------------->
> > >-------------------------------------------------------------------
> ---------|
> ---------|
> >
> |
> |
> > | To: ADSM-
> L AT VM.MARIST DOT EDU |
> > | cc: (bcc: Henrik
> Wahlstedt) |
> > | Subject: Re: question: db-
> backup |
> > >-------------------------------------------------------------------
> ---------|
> ---------|
> >
> >
> >
> >
> >
> > Hi Henrik,
> >
> > thanks for your answer.
> > But if we start the backup while application has the db allocated, we
> usually
> > should get the "file in use"-message.
> > Or not?
> >
> > At the moment we are testing the OSA-Gigabit-Adapter to backup our
> Nodes ;)
> > Then the problem with the network should be solved...
> >
> > --
> > regards / Mit freundlichen Gruessen
> > Joachim Stumpf
> > Datev eG
> > Nuremberg - Germany
> >
> >
> > Henrik Wahlstedt <SHWL AT STATOIL DOT COM> (Mittwoch, 20. März 2002,
> 11:13:35, CET):
> >
> > >
> > >
> > >
> > > Hey,
> > > As you write 'To backup the db the application which uses the db
> has to be
> > down.
> > > ' answers your question. No.
> > > Aren´t you having a networkproblem with speed less than 0,5Gb/hour?
> > >
> > > //Henrik
> > >
> > >
> > > |--------+------------------------->
> > > | | "Stumpf, |
> > > | | Joachim" |
> > > | | <joachim.stumpf|
> > > | | @DATEV.DE> |
> > > | | Sent by: "ADSM:|
> > > | | Dist Stor |
> > > | | Manager" |
> > > | | <ADSM-L AT VM DOT MARI|
> > > | | ST.EDU> |
> > > | | |
> > > | | |
> > > | | 2002-03-20 |
> > > | | 10:45 |
> > > | | Please respond |
> > > | | to "ADSM: Dist |
> > > | | Stor Manager" |
> > > | | |
> > > |--------+------------------------->
> > >
> > >---------------------------------------------------------------------
> -------|
> -------|
> > > |
> > |
> > > | To: ADSM-L AT VM.MARIST DOT EDU
> > |
> > > | cc: (bcc: Henrik Wahlstedt)
> > |
> > > | Subject: question: db-backup
> > |
> > >
> > >---------------------------------------------------------------------
> -------|
> -------|
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Hi together,
> > >
> > > We have a database to backup with TSM. This db is 2GB and the
> backup takes 5
> > > hours.
> > > To backup the db the application which uses the db has to be down.
> > >
> > > Is it possible to start the application during the db-backup?
> > >
> > > --
> > > regards / Mit freundlichen Gruessen
> > > Joachim Stumpf
> > > Datev eG
> > > Nuremberg - Germany
> > >
> > >
> > >
> > > -------------------------------------------------------------------
> > > Statoil: The information contained in this message may be
> > > Statoil: The information contained in this message may be
> CONFIDENTIAL and is
> > > intended for the addressee only. Any unauthorised use,
> dissemination of the
> > > information or copying of this message is prohibited. If you are
> not the
> > > addressee, please notify the sender immediately by return e-mail
> and delete
> > this
> > > message.
> > > Thank you.
> > >
> >
> >
> > -------------------------------------------------------------------
> > Statoil: The information contained in this message may be
> CONFIDENTIAL and is
> > intended for the addressee only. Any unauthorised use, dissemination
> of the
> > information or copying of this message is prohibited. If you are not
> the
> > addressee, please notify the sender immediately by return e-mail and
> delete this
> > message.
> > Thank you.
> >
> >
>
>
>
|
