Hi all

Thank you Micheal
It's working perfectly

have a nice day

Luc




Christian Svensson <Christian.Svensson AT CRISTIE DOT SE>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-09-20 12:42 AM
Please respond to "ADSM: Dist Stor Manager"

 
        To:     ADSM-L AT VM.MARIST DOT EDU
        cc: 
        Subject:        SV: SQL 2000 server restore


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:ADSM-L AT VM.MARIST DOT EDU] För 
Wheelock, 
Michael D
Skickat: den 17 september 2004 18:46
Till: ADSM-L AT VM.MARIST DOT EDU
Ä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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Luc Beaudoin
Sent: Friday, September 17, 2004 11:17 AM
To: ADSM-L AT VM.MARIST DOT EDU
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).
**************************************************************************************************