[SQL] SQL 修复命令
2023-09-14 09:01:22 时间
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 Server 2005 express没有权限,sa不能登录问题。
- 解决SQL Server 阻止了对组件 'Ad Hoc Distributed Queries' 的 STATEMENT'OpenRowset/OpenDatasource' 的访问的方法
- Oracle 查询并删除重复记录的SQL语句
- mysql操作索引的sql语句
- 读书笔记--SQL必知必会14--组合查询
- 通过Linux命令过滤出binlog中完整的SQL语句
- SQL语句Left join 中On和Where的用法区别
- Sql Server 2008完全卸载方法(其他版本类似)
- Atitit 命令行执行sql 跨语言 目录 1.1. 无需输入密码,那就不要-p参数即可1 1.2. 4.使用mysql命令执行1 1.3. 5.mysql命令执行sql,并将查询结果保存到
- Database之SQLSever:SQLSever数据库管理学习并深入理解SQL命令语句进阶综合篇《初级→中级→高级》(持续更新,建议收藏)
- 成功解决SQL Server软件中出现的18470问题
- Database之SQLSever:SQLSever数据库管理(GUI法/SQL语句命令法两种方法实现备份(完整备份、差异备份、日志备份)、还原、删除、修改数据库等案例)之详细攻略
- 在linux命令下导出导入.sql文件的方法
- 肝通宵写了三万字把SQL数据库的所有命令,函数,运算符讲得明明白白讲解,内容实在丰富,建议收藏+三连好评!
- 暴刷 SQL 导航
- php导入sql文件
- 008-Hadoop Hive sql语法详解3-DML 操作:元数据存储
- UNNEST 就是将sql 里面的数据展开
- 测试开发 | 软件测试最常用的 SQL 命令 :通过实例掌握基本查询、条件查询、聚合查询
- WAF——针对Web应用发起的攻击,包括但不限于以下攻击类型:SQL注入、XSS跨站、Webshell上传、命令注入、非法HTTP协议请求、非授权文件访问等
- 下载 Microsoft SQL Server JDBC 驱动程序
- 灵活好用的sql monitoring 脚本 part6
- 【MySQL】常用的SQL命令_Unit02
- sql的介绍——SQL Server数据库管理系统