SQL 2005 master database

Networking/Security Forums -> Databases

Author: duster PostPosted: Fri Apr 23, 2010 6:40 pm    Post subject: SQL 2005 master database
Im trying to put sql 2005 master database in single user mode. this is what i have done so far with no luck.

1. stop all related SQL services //so that nothing can log in before i do
2. from cmd prompt i issue command net start mssqlserver -m or /m
3. when i log into studio manager i notice master still isnt in single mode
4. i tried to put it in single user mode via the GUI also wont allow me

any ideas?

Author: operat0r2 PostPosted: Mon Apr 26, 2010 5:56 pm    Post subject:
maybe the user can't run in single mode you can try sysrun.exe c:\windows\cmd.exe and start it from the command line and not from net start etc ...

you can also use M$ process explorer and run it as SYSTEM and see if any SQL threads are open just search for SQL and kill any tasks you find Smile

also google and make sure you got the syntax right to start sql as single I dont thing its net start ... from what I can remember ?

Author: abrasmith89 PostPosted: Fri Dec 17, 2010 11:58 am    Post subject:
Master database is system database and it contains information about running server's configuration. When SQL Server 2005 is installed it. If you have to use of the Setup command to rebuild the master database has changed in this Microsoft SQL Server release. Without the master page you can not successfully start the SQL server.

Author: racyhall11 PostPosted: Sat Dec 18, 2010 7:28 am    Post subject:
SQL server 2005 is the best database. Master database is the one which is absolutely must have database. Without SQL Server database can not be started. It creates master, model, msdb, tempdb resource and distribution.

Networking/Security Forums -> Databases

output generated using printer-friendly topic mod, All times are GMT + 2 Hours

Page 1 of 1

Powered by phpBB 2.0.x © 2001 phpBB Group