SQL Server Performance Forum – Threads Archive

sql server in single user mode

When I am trying to make an instance of sql server in single user mode by running the command sqlservr.exe -c-m -s computernamesqlserverinstance from command prompt , I am getting an error
Error: Instance name exceeds maximum length
Aborting Initialization
What to do now
IS there any other method by which I can bring the instance of sql server to single user mode. Once I finished my work in single user mode..I want to make the instance to previous state ..How to accompolish this?

You must switch to the appropriate directory (for the instance of Microsoft SQL Server 2000 you want to start) in the command window before starting sqlservr.exe Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

I have done the same and i got that error.what shoud I do now

How many characters has instance name?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

22 characters(alphanumeric)

Instance name are limited to 16 characters. (Check BOL). Short in the dark (before change your instance name up to 16): try to run Star command writing up to 16 characters.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

What’s a Star Command? Is it something sci-fi? Tom Pullen
DBA, Oxfam GB

Are those 22 characters involves the machine name aswell? SQL Server can be started from command line, using the SQLSERVR.EXE. This EXE has some very important parameters with which a DBA should be familiar with. -m is used for starting SQL Server in single user mode and -f is used to start the SQL Server in minimal confuguration mode. Check out SQL Server books online for more parameters and their explanations.
Or the star command.. is from Battlestart gallactica?? [8D] Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Star: Stupid.Translation.ar[<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />] Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important Bertrand Russell All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>