Is there a way of entering maintenance mode ("-m") through Enterprise
Manager (2000), rather than running sqlservr.exe directly?
Thanks!
You can add it as a start up parameter (right-click your server, startup parameters), these are
stored in the registry. But as this is a one-time, it is easier to use Windows Services applet, and
add the parameter there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neil W." <neilw@.netlib.com> wrote in message news:e97bUWk2FHA.1292@.TK2MSFTNGP12.phx.gbl...
> Is there a way of entering maintenance mode ("-m") through Enterprise
> Manager (2000), rather than running sqlservr.exe directly?
> Thanks!
>
Wednesday, February 15, 2012
Entering maintenance mode through Enterprise Manager?
Labels:
database,
entering,
enterprise,
enterprisemanager,
exe,
maintenance,
manager,
microsoft,
mode,
mysql,
oracle,
running,
server,
sql,
sqlservr
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment