Hi Michael. This information helps me a lot but I wonder do you know if this command is also presents in SQL Server 7.0. And if I understand you correct you this command can rebuild or creates a new Master Database without a new installation of MS SQL Server?
Best Regards Christian Svensson -----Ursprungligt meddelande----- Från: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] För Wheelock, Michael D Skickat: den 17 september 2004 18:46 Till: [EMAIL PROTECTED] Ämne: Re: SQL 2000 server restore Hi, There is a Q article on how to restore master on microsoft's website. Basically you have to put down a blank master with the rebuildm.exe utility. Then you can start the sql server interactively (ie. Not through the service) and recover your real master through tsm. Once done, you can start the service and recover the other databases. Michael Wheelock Integris Health -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin Sent: Friday, September 17, 2004 11:17 AM To: [EMAIL PROTECTED] Subject: SQL 2000 server restore Hi all I'm testing a SQL 2000 server restore ... I restored the OS (win2000) + the system objects .... Now I want to restore my SQL databases ... but the MASTER DB is not there cause it's exclude in my windows client dsm.opt file. So I am not able to start my SQL server service ... I have the message could not connect ... Even when I start the TSM SQL agent .. I see the DB to restore but when I click restore .. I have an error message saying that " ACO5424E" could not connect to SQL server How can I restore my SQL databases ... Thanks Luc Beaudoin Administrateur Réseau / Network Administrator Hopital General Juif S.M.B.D. / Jewish General Hospital Tel: (514) 340-8222 ext:4318 ************************************************************************************************** This e-mail may contain identifiable health information that is subject to protection under state and federal law. This information is intended to be for the use of the individual named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited and may be punishable by law. If you have received this electronic transmission in error, please notify us immediately by electronic mail (reply). **************************************************************************************************
