Wednesday, February 15, 2012

Entering maintenance mode through Enterprise Manager?

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 par
ameters), these are
stored in the registry. But as this is a one-time, it is easier to use Windo
ws 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...[
vbcol=seagreen]
> Is there a way of entering maintenance mode ("-m") through Enterprise
> Manager (2000), rather than running sqlservr.exe directly?
> Thanks!
>[/vbcol]

No comments:

Post a Comment