Hej
There is a redbook covering SQL backup/restore, http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246148.pdf Maybe ou will find something there.... /Niklas -----Original Message----- From: Christian Svensson [mailto:[EMAIL PROTECTED] Sent: den 10 mars 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]
