Start master in Single-User Mode (11.5) WinNT

[ASWETICH]

I need to do a master restore and have been unable to start the server in Single-User mode. I have been going to "Server Config" and adding -m to the "Command Line" option. Is the how it should work ?

 

[cellis12]

I don't think you can put a dataserver into single-user mode. If you mean to put a database into single-user mode you use the sp_dboption command, like so...

USE master
go
EXEC sp_dboption 'your_db_name','single user',true
go
USE your_db_name
go
CHECKPOINT
go

whrere 'your_db_name' is the name of the database. I think you need to make sure that you are using a privileged account (like sa) and that there is no one else connected to the database.

Hope that helps.

~Chuck

 

[RajD]

Recovering the master Database
This example rebuilds the master database on a 17MB (8704 2K pages) master device:

d:\sybase\bin> bldmastr -d d:\devices\master.dat -s8704 -m
The following example loads the most recent backup of the master database from tape with the load database command:

load database master from "\\.\TAPE0"
After the load database command completes successfully, Adaptive Server shuts down. Watch for any error messages during the load and during the shutdown.