Changing SQL Server Advanced Properties with WMI Provider
来源:互联网 发布:大数据挖掘培训可靠不 编辑:程序博客网 时间:2024/05/21 07:49
Suppose the file system is corrupted,in which case you need to restore every database, including the master database. To restore the master database, you need to start the SQL Server in single-user mode. Insert the –m option into the existing startup options, and then restart the database.
The ChangeStartupParameters.ps1 script is shown in the following example. The script first uses the Get-WmiObject cmdlet to instantiate a SqlServiceAdvancedProperty object that corresponds to the STARTUPPARAMETERS property of the default instance. Next, it invokes the SetStringValue method to pre-append the -m option to the string of startup parameters. The ‘‘`n’’ in the script is used to print out the new line character.
# . for the local computer
# If you want to connect to a remote machine, specify the machine name here.
$strComputer='.'
# Name of the targeted service. Here the default SQL Server service is targeted.
# For a named instance INSTANCE1, use "MSSQL`$INSTANCE1"
$strServiceName = "MSSQLSERVER"
$ap=Get-WmiObject -computerName $strComputer –namespace
root\Microsoft\SqlServer\ComputerManagement10 -class SqlServiceAdvancedProperty `
-filter "ServiceName='$strServiceName' and PropertyName='STARTUPPARAMETERS'"
$ap.SetStringValue("-m " + $ap.PropertyStrValue) | Out-Null
# Confirm the "-m" option has been added.
$ap=Get-WmiObject -computerName $strComputer –namespace
root\Microsoft\SqlServer\ComputerManagement10 -class SqlServiceAdvancedProperty `
-filter "ServiceName='$strServiceName' and PropertyName='STARTUPPARAMETERS'"
Write-Host "The startup parameters have been changed to `n" $ap.PropertyStrValue
Note:The new startup option will take effect the next time SQL Server starts.
To look at the read-only properties of the SQL Server service:
$strComputer='.'
$strServiceName = "MSSQLSERVER"
$properties=Get-WmiObject -computerName $strComputer –namespace
root\Microsoft\SqlServer\ComputerManagement10 -class SqlServiceAdvancedProperty
-filter "ServiceName=’$strServiceName’"
$properties | Where-Object {$_.IsReadOnly} | Format-table -wrap PropertyName,
PropertyStrValue, PropertyNumValue
- Changing SQL Server Advanced Properties with WMI Provider
- Managing SQL Server Services with WMI Provider
- Managing SQL Server Client Aliases with WMI Provider
- Managing Server Network Protocols with WMI Provider
- WMI Provider for Server Events
- Managing Client Network Protocols with WMI Provider
- 运行SQL server2005 配置管理工具出现“Cannot connect to WMI provider. You do not have permmission or the server”
- Advanced SQL Server Locking
- SQL Server配置管理WMI问题
- Changing the name of your SQL Server
- Advanced SQL Injection with MySQL
- Advanced SQL Injection with MySQL
- Advanced SQL Injection with MySQL
- Advanced SQL Server Monitor with Performance Graph, Analysis and Version Control
- 安装 DNS WMI Provider
- Advanced SQL Injection In SQL Server Applications
- Microsoft® SQL Server 2005: Changing the Paradigm
- Turbocharge SQL with advanced Oracle indexing
- 关于viewDidLoad里调用presentModalViewController的问题
- Android framework系统默认设置修改
- 上传了资料--分布式Java
- intent大全
- 最简单的递归函数
- Changing SQL Server Advanced Properties with WMI Provider
- eclipse 下 svn 切换用户问题和异常处理
- sql server查询表前多少行 数据进行更新
- windows dos 常用命令详解 ping ,netstat命令 (一)
- 使用printk进行内核调试的方法
- Java 理论与实践: 并发集合类
- tabifier工具css代码,javascript代码,html代码规范
- 【每日听力活动训练】第三期 0322
- 彻底明白 Java 语言中的IO系统