Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 batch file stop\start services (3 instances)

Author  Topic 

ells
Starting Member

25 Posts

Posted - 2008-01-28 : 04:43:48
I am in need of setting up the following for each of two SQL 2000 instances on one box. I have seen the code

NET STOP "SQL Server Analysis Services (MSSQLSERVER)"
NET START "SQL Server Analysis Services (MSSQLSERVER)"

I am thinking of one script for instance s1 to stop sql server and then start it. One script for instance s2 to stop sql server and then start it.

Sorry but having trouble finding an answer that copes with multiple instances. Having a really bad morning.

Thanks.
Mark

ells
Starting Member

25 Posts

Posted - 2008-01-28 : 05:04:12
sorry,
got it sorted.
Thanks.
M
Go to Top of Page
   

- Advertisement -