Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how to restore master db sql 6.5

Posted on 2006-05-16
5
Medium Priority
?
655 Views
Last Modified: 2011-09-20
I'm trying to restore the master database on SQL server6.5. I get and error that say that I have to be on single user mode.  How may I start SQL in single user mode.

or better yet how to restore the master DB in SQL 6.5

Thank you
0
Comment
Question by:jolivare
3 Comments
 

Author Comment

by:jolivare
ID: 16694325
I try runing this comand on sqlservr.exe -m and and it stop here

launched startup procedure 'sp_sqlregister'
0
 
LVL 20

Accepted Solution

by:
Sirees earned 1000 total points
ID: 16694328
0
 
LVL 3

Assisted Solution

by:lokeshgm7
lokeshgm7 earned 1000 total points
ID: 16731954
Here is what you need to do.

1. Stop MSSQLServer and SQLServerAgent services.
2. From a command prompt, enter this command:

sqlservr.exe -m

"Do not close the command prompt window after executing this command. Now it is enabled for only one connection."

3. Run Enterprise Manager to restore the master database from the backup.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question