Solved

Single mode SQL Instance

Posted on 2007-03-21
4
298 Views
Last Modified: 2012-08-13
how do we put an instance of a SQlServer(Customer) in single mode?
I did
c:\program files\Microsoft Sql server\MSSQL$Customer\BINN>sqlservr -m


I get this
   initerrlog: Could not open error log file 'd:\program files\microsoft sql server\MSSQL\log\ERRORLOG'. Operating system error =
32(The process cannot access the file because it is being used by another process

Any inputs
0
Comment
Question by:ohemaa
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
mcmonap earned 250 total points
ID: 18768053
Hi ohemaa,

To change the mode whilst SQL server is running use the sp_dboption, check out the syntax here:
http://msdn2.microsoft.com/en-us/library/ms187310.aspx
0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
ID: 18769343
to put the entire instance of sql server into single user mode, you have to first stop the running sql server instance (stop service).

anyhow, then you have to start:
c:\program files\Microsoft Sql server\MSSQL$Customer\BINN>sqlservr -m -c

note: sp_dboption is only to put a single database in single-user mode.

0
 

Author Comment

by:ohemaa
ID: 18772132
I issued this:

c:\program files\Microsoft Sql server\MSSQL$Customer\BINN>sqlservr -m -c
it only puts the Sqlserver in single user mode not the instance even though the path is pointintg to the instance
i am able to restore the master database but not the instance master Db
0
 

Author Comment

by:ohemaa
ID: 18772864
I am just trying to restore the master DB on the Instance ,...help help
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server - Set Value of Multiple Fields in One Query 10 25
Query Syntax 17 36
SQL - Update field defined as Text 6 17
Rename a column in the output 3 14
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

803 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