>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:[EMAIL PROTECTED] Sent: 10 March 2003 13:22 To: [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED] Bo Nielsen <Bo. [EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent by: "ADSM: cc: Dist Stor Subject: SV: Backup MS SQL master.mdf Manager" <ADSM- [EMAIL PROTECTED]> 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 * [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sendt: 10. marts 2003 11:31 Til: [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED] 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.
