[SQL] SQL 修复命令
2023-09-14 08:59:35 时间
You should run the repair from the original installation media, using the following command line:
Repair the common shared components and features first, and then repeat the command to repair the instances installed. During the repair process, the setup dialog box disappears. As long as the progress window does not show an error, the repair process is proceeding as expected.
Note The following error messages can be found as text messages in the event log or in the Setup logs that are located in one of the following folders, and they indicate that you should repair your affected instance being proceeding further:
setup.exe /ACTION=REPAIR /INDICATEPROGRESS=TRUE
Repair the common shared components and features first, and then repeat the command to repair the instances installed. During the repair process, the setup dialog box disappears. As long as the progress window does not show an error, the repair process is proceeding as expected.
Note The following error messages can be found as text messages in the event log or in the Setup logs that are located in one of the following folders, and they indicate that you should repair your affected instance being proceeding further:
- For SQL Server 2008 and for SQL Server 2008 R2:
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap
- For SQL Server 2012:
C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap
参见:
https://msdn.microsoft.com/en-us/library/cc646006%28v=SQL.105%29.aspx
https://support.microsoft.com/en-us/kb/969052
相关文章
- 【SQL 性能优化】表的三种连接方式
- MICROSOFT SQL SERVER TO POSTGRESQL MIGRATION USING PGLOADER
- SQL Server基础Sql语句复习
- C#操作SQL Server中的Image类型数据
- java.sql.SQLException: The SQL statement must not be null or empty.这个错误
- SQL优化经验总结34条
- [SQL] 命令远程恢复数据库
- [SQL] sql server中如何查看执行效率不高的语句
- [SQL] SQL 修复命令
- SQL SERVER CHARINDEX函数
- SQL SERVER服务器链接连接(即sql server的跨库连接)
- Sql Server中sql语句自动换行
- mybatis 批量插入值的sql
- Database之SQLSever:SQL命令实现查询之多表查询、嵌套查询、分页复杂查询,删除表内重复记录数据、连接(join、left join和right join简介及其区别)等案例之详细攻略
- SQL基础【十八、事物】(sql事物慎用,还是写业务逻辑代码好一些,入伙涉及到更换数据啥的很麻烦!)
- 肝通宵写了三万字把SQL数据库的所有命令,函数,运算符讲得明明白白讲解,内容实在丰富,建议收藏+三连好评!
- 力扣 SQL 608. 树节点
- Node.js:insert-sql帮助开发者生成SQL插入语句
- 动态SQL语句
- laravel打印sql
- sql查询第10条到第20条数据
- 【ctfhub】SQL注入字符型注入
- SQL Server中关于表的基本命令