需要脚本 - DBA [英] Scrip Needed - DBA
问题描述
b
我需要两个PS脚本来停止并启动默认和命名实例的SQL服务器相关服务(多个Windows服务器) 。$
发动机
代理商
分析
报告
整合
浏览器
输出如下所示 -
服务器名称服务名称,状态,状态停止前:
SERVERNAME1 MSSQLSERVER运行自动
SERVERNAME1 MSSQLSERVERAGENT运行手册
SERVERNAME2 MSSQLSERVER运行自动
SERVERNAME2 MSSQLSERVERAGENT运行自动
服务器名称服务名称,状态,状态停止后:
SERVERNAME1 MSSQLSERVER Stoped Automatic
SERVERNAME1 MSSQLSERVERAGENT已停止手动
SERVERNAME2 MSSQLSERVER已停止自动
SERVERNAME2 MSSQLSERVERAGENT已自动停止
Hi there,
I need two PS script to stop and start the SQL server related services (Multiple windows Server) for both default and Named instance.
Engine
Agent
Analysis
Report
Integration
browser
Output should be like as below -
Server name Service Name,status,state BEFORE STOP:
SERVERNAME1 MSSQLSERVER Running Automatic
SERVERNAME1 MSSQLSERVERAGENT Running Manual
SERVERNAME2 MSSQLSERVER Running Automatic
SERVERNAME2 MSSQLSERVERAGENT Running Automatic
Server name Service Name,status,state AFTER STOP:
SERVERNAME1 MSSQLSERVER Stoped Automatic
SERVERNAME1 MSSQLSERVERAGENT Stopped Manual
SERVERNAME2 MSSQLSERVER Stopped Automatic
SERVERNAME2 MSSQLSERVERAGENT Stopped Automatic
请帮助我,谢谢你提前得到了很多帮助。
Please help me on this, thank you so much in advance for your help.
问候,Dhanapal
Regards, Dhanapal
推荐答案
此处还可以找到脚本: http://gallery.technet.microsoft.com/
Also find scripts here: http://gallery.technet.microsoft.com/
了解PowerShell:
https://mva.microsoft.com/en-us / training-courses / getting-started-with-microsoft-powershell-8276
Learn PowerShell: https://mva.microsoft.com/en-us/training-courses/getting-started-with-microsoft-powershell-8276
脚本请求:
https://gallery.technet.microsoft.com/scriptcenter/site/requests
这篇关于需要脚本 - DBA的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!