Hi Bo!
I´m already use the TDP for backup the data in the databas. But to recovery
the databas from a disaster do I need to restore the master.mdf before I
use the TDP. So I just wonder how I can backup the master.mdf.
Do I realy need to use a open file manager? And is the master.mdf
syncronized to another files?
If I don´t backup that file(s). And the server going down some how.
I need to reinstall the SQL software and the service pack. That takes to
long time and everyone don´t writeing down what they have done with the SQL
Software.
So we realy need a Bare Metal solution for it. And I think I got a plan.
But I just need answer on my questions.

Med Vänliga Hälsningar/Best Regards
Christian Svensson

-------------------------------------------------------------------------------

Cristie Nordic AB
Box 2
SE-131 06 Nacka
Sweden

Phone : +46-(0)8-718 43 30
Mobil : +46-(0)70-325 15 77
eMail : christian.svensson AT cristie DOT se
MSN : issen007 AT hotmail DOT com


                                                                       
                      Bo Nielsen <Bo.                                  
                      Nielsen AT COOP DOT DK>         To:       ADSM-L AT 
VM.MARIST DOT EDU
                      Sent by: "ADSM:          cc:                     
                      Dist Stor                Subject:  SV: Backup MS SQL 
master.mdf
                      Manager" <ADSM-                                  
                      L AT VM.MARIST DOT EDU>                                 
                                                                       
                                                                       
                      2003-03-10 12:28                                 
                      Please respond to                                
                      "ADSM: Dist Stor                                 
                      Manager"                                         
                                                                       
                                                                       




Hi Christian,

you will need TDP2.2 for SQL (Tivoli Data Protection), to backup the SQL
databases.
and that incl. both master and model.

 Med venlig hilsen/Regards
 Bo Nielsen
                                               * 43 86 46 71
 COOP Danmark A/S                * (Internt postcenter): 6230
 IT-Driftscenter                          *   bo.nielsen AT coop DOT dk

Pr. 1. januar 2002 blev COOP Danmark A/S dannet. COOP Danmark A/S er den
førende udbyder af dagligvarer i Danmark og består af butikskæderne
Kvickly,
SuperBrugsen, Dagli'Brugsen, LokalBrugsen, Irma og Fakta samt Dansk
Kaffekompagni A/S. COOP Danmark A/S er en del af virksomheden COOP Norden,
der repræsenterer en samlet omsætning på ca. 100 mia. kr. og har 64.000
ansatte. Det er således Nordens største aktør på dagligvaremarkedet.
Foreningerne FDB, KF (Sverige) og COOP NKL (Norge) er 100% ejer af COOP
Norden.




-----Oprindelig meddelelse-----
Fra: Christian Svensson [mailto:Christian.Svensson AT CRISTIE DOT SE]
Sendt: 10. marts 2003 11:31
Til: ADSM-L AT VM.MARIST DOT EDU
Emne: Backup MS SQL master.mdf


Hi all TSMers!
I got just a prodject on my desk who says that I need to found a good
disaster recovery solution for Microsoft SQL 2000.
And I know how to get back the system in 5 min. But I still don´t know how
to get back the SQL server with out any installation CDs.
I have come so far so I backup all the program files but I still have
problem to backup master.mdf.
So I got two questions.
Do anyone know if master.mdf need to be syncronize to another files?
And do master.mdf need to backup with a Open File Manager or can TSM take a
backup of that file with out any Open File Manager?

Med Vänliga Hälsningar/Best Regards
Christian Svensson

----------------------------------------------------------------------------

---

Cristie Nordic AB
Box 2
SE-131 06 Nacka
Sweden

Phone : +46-(0)8-718 43 30
Mobil : +46-(0)70-325 15 77
eMail : christian.svensson AT cristie DOT se
MSN : issen007 AT hotmail DOT com