Gary Minnock (9/9/2008)
Also I noticed that when Server 1 restarts the SQL services do not automatically restart as they should.
Gary
go into sql server configuration manager, right click the service and check it is configured to start automatically on server restart. You could also do this via the services applet and check service set to automatic
---------------------------------------------------------------------