That's normal. If you read thru' the Redbook for TDP for SQL it basically walks
you thru' the restore process.
First start the SQL server in single user mode.
sqlserver.exe -m
After you restore the master dtabase (which gives an error) Start the SQL
Server in the normal mode as a service.
Then restore msdb (relocate if needed)
then the model (relocate if needed).
After the system databases are in place you can then start the restore of your
databases.
Rajesh Oak
Enterprise Storage Administrator
Blue Cross Blue Shield of Michigan.
--
--------- Original Message ---------
DATE: Wed, 20 Aug 2003 10:13:46
From: "Amini, Mehdi" <Mehdi.Amini AT VALUEOPTIONS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Cc:
>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:Eric-van.Loon AT KLM DOT COM]
>Sent: Wednesday, August 20, 2003 9:49 AM
>To: ADSM-L AT VM.MARIST DOT EDU
>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: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.
>**********************************************************************
>
>
>**********************************************************************
>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.
>
>**********************************************************************
>
____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
|
