Hi,
you have to start SQL in single user mode, with the startup parameter -e, Note:
-e is small and the TDP Documentation says -E I think, when you use -E the sql
server won't start.
Markus Veit
An: ADSM-L AT VM.MARIST DOT EDU
Kopie:
Thema: Re: SV: Backup MS SQL
master.mdf
owner-adsm-l AT VM.MARIST DOT EDU
Received : 10.03.2003
13:45
Bitte antworten an "ADSM:
Dist Stor Manager"
>From what I remember you need to start SQL in single user mode (from DOS cmd
line), then restore master with TDP. Then restart in normal mode and restore
the other databases with TDP.
-----Original Message-----
From: Christian Svensson [mailto:Christian.Svensson AT CRISTIE DOT SE]
Sent: 10 March 2003 13:22
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SV: Backup MS SQL master.mdf
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
Any e-mail message from the European Central Bank (ECB) is sent in good faith
but shall neither be binding nor construed as constituting a commitment by the
ECB except where provided for in a written agreement.
This e-mail is intended only for the use of the recipient(s) named above. Any
unauthorised disclosure, use or dissemination, either in whole or in part, is
prohibited.
If you have received this e-mail in error, please notify the sender immediately
via e-mail and delete this e-mail from your system.
|
