Hi Mehdi! You can only restore Master Databas in Singel User Mode. And to start your SQL Server in Singel User Mode do you need to start SQLServe.exe with Switch -m. And you can find the file in directory \Binn
And when you restore your Master databas should your SQL Server shutdown and your should got a error. Ignore the error and start your SQL Server in Multi-User mode. (Normal Mode). Then can you restore all the other databas that you want back from your backup. So my point is. You can ONLY restore Master Databas in Singel User mode. And all the others databas can you only restore in Multi User mode (Normal mode). And if you want to know what the error means. It�s only tells you that the databas is successfully restored but the TDP could not reconnect to the server after the restore. And that is becuse the SQL Server went down after you restore the master databas. I hope I answer your question. Best Regard Christian Svensson -----Ursprungligt meddelande----- Fr�n: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Amini, Mehdi Skickat: den 20 augusti 2003 16:14 Till: [EMAIL PROTECTED] �mne: Re: Restoring SQL Database Thanks Eric, I've done this...but when I go and select the databases to restore (inclusing the Master) here is what happens: Master Restore Failed [microsoft][ODBC SQL Server Driver][SQL Server]the master database has been successfully restore. At the beginning it says failed...Yet at the end it says successful???? Model Restore failed [SQL DMOT]this server connection has been unexpectedly broken and cannot be reconnected. Same for other Databases Mehdi Amini LAN/WAN Engineer ValueOptions 12369 Sunrise Valley Drive Suite C Reston, VA 20191 Phone: 703-390-6855 Fax: 703-390-2581 -----Original Message----- From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 9:49 AM To: [EMAIL PROTECTED] Subject: Re: Restoring SQL Database Hi Mehdi! Checkout the manual "Data Protection for Microsoft SQL Server Installation and User's Guide" Appendix C. Here is a part called "Setting user mode" which explains how to place the SQL server in the single-user mode. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -----Original Message----- From: Amini, Mehdi [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 14:34 To: [EMAIL PROTECTED] Subject: Restoring SQL Database While restoring SQL Database with replace option selected I am getting this error message "Restore failed [Microsoft][ODBC SQL Server Driver] [SQL Server] Restore DATABASE must be used in single user mode when trying to restore Master Database." SQL server 2000 SQL TDP 2.2.1 Thanks for any help Mehdi Amini LAN/WAN Engineer ValueOptions 12369 Sunrise Valley Drive Suite C Reston, VA 20191 Phone: 703-390-6855 Fax: 703-390-2581 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.If you have received this email in error please notify the sender by email, delete and destroy this message and its attachments. ********************************************************************** ********************************************************************** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. ********************************************************************** ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.If you have received this email in error please notify the sender by email, delete and destroy this message and its attachments. **********************************************************************
