Start sql server after main server running ?

Posted by jmls on 28-May-2013 05:48

11.1 enterprise, Windows server

After a machine reboot, our db server came up fine - however the sql server that is configured as a secondary sql-only server seems to be MIA

Can I start this secondary server without bringing down the database broker ?

As you can tell, I'm not a proper dba

Thanks

All Replies

Posted by gus on 28-May-2013 11:37

you can start a secondary broker with the -m3 command line parameter.

see secondary brokers section in chapter 3 of database administration guide for more info.

Posted by jmls on 28-May-2013 11:48

Thanks Gus. Wasn't sure where to look. I've restarted the server in

the meantime, and the sql process came up this time.

filed

This thread is closed