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:Mehdi.Amini AT VALUEOPTIONS DOT COM]
Sent: Wednesday, August 20, 2003 14:34
To: ADSM-L AT VM.MARIST DOT EDU
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.
**********************************************************************