April 24, 2003 at 2:21 pm
Hi,
After starting is sigle user mode, I start enterprise MGR, attempt to restore but I need to start sql server service first. Then I am able to select the restore DB option and now I get a Connection Transact, Get overlapped result, connection broken. This is version 7.0.
Am I doing something wrong?????
Karen
April 24, 2003 at 3:07 pm
I recommend in every restore to use QA and learn and get used to use the tsql commands.
To restore the master db, I start sql server with sqlservr.exe -m parameter. Then connect with QA, and restore the master db wth the syntax:
RESTORE DATABASE Master FROM [Backup]
then sql server will stop and you must start it aggin.
April 24, 2003 at 4:53 pm
Only for restoring master database, you must start sql server with sqlservr.exe -m, then you can do the restore.
Robert
April 25, 2003 at 1:00 pm
Thanks for your suggestions.
Karen 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply