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. **********************************************************************
