传送给数据库,修复命令

I successfully installed SQL Server Profiler 2008 R2 Profiler without
uninstalling SQL 2008 R2 Express with the help of my colleague.

I successfully installed SQL Server Profiler 2008 R2 Profiler without
uninstalling SQL 2008 R2 Express with the help of my colleague.

错误:连接数据库的时候提示:SQL Server 检查评定到基于一致性的逻辑 I/O 错误
校验和不科学

 

To install, first make sure you have the Enterprise Edition DVD.

To install, first make sure you have the Enterprise Edition DVD.

C:\Documents and Settings\Administrator>”C:\Program
Files\Microsoft SQL Server\100\Setup Bootstrap\Release\setup.exe”
/q /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER
/SQLSYSADMINACCOUNTS=administrator /SAPWD=password 

 

run the setup.exe of the installer with these parameters:

run the setup.exe of the installer with these parameters:

 

You should run the
repair from the original installation media, using the following command
line:

setup.exe /FEATURES=Tools /Q /INDICATEPROGRESS /ACTION=Install
/INSTANCENAME=SQLSERVER2008R2Ent /BROWSERSVCSTARTUPTYPE=Automatic
/AGTSVCACCOUNT=”NT AUTHORITY\NETWORK SERVICE”
/IACCEPTSQLSERVERLICENSETERMS

setup.exe /FEATURES=Tools /Q /INDICATEPROGRESS /ACTION=Install
/INSTANCENAME=SQLSERVER2008R2Ent /BROWSERSVCSTARTUPTYPE=Automatic
/AGTSVCACCOUNT=”NT AUTHORITY\NETWORK SERVICE”
/IACCEPTSQLSERVERLICENSETERMS

传送给数据库,修复命令。施行达成后就ok了,更为详细消息,参阅:

setup.exe /ACTION=REPAIR
/INDICATEPROGRESS=TRUE

where the value of “/INSTANCENAME” is equal to the instance name of
the Server Instance that you wish you use.

where the value of “/INSTANCENAME” is equal to the instance name of
the Server Instance that you wish you use.

地点计算机上安装的MS SQL Server 2010 奥德赛2或许因为硬盘原因,导致SQL
Server服务不能起动,在事件查看器中观察若干不当和消息,当中有两条晋升恐怕master损坏:
1、错误:传递给数据库 ‘master’ 中的日志扫描操作的日记扫描号 (1八四:41陆:一)
无效。此错误大概提示数据损坏,只怕日志文件(.ldf)与数据文件(.mdf)分歧盟。要是此错误是在复制时期出现的,请重新创造发表。不然,假如该难点导致运转时期出错,请从备份还原。
②、消息:不能苏醒 master 数据库。SQL Server 不只怕运转。请利用总体备份还原
master 数据库,修复它,大概重新生成它。有关如何重新生成 master
数据库的详细音讯,请参阅 SQL Server 联机丛书。

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.

参照最初的作品地址:

参照原来的作品地址:

重新安装SQL
Server难题轻易消除,但太耗时。google到一个神速的复原措施,分享如下:

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:

1、复制model.mdf、mastlog.ldf、model.mdf、modellog.ldf、msdbdata.mdf、msdblog.ldf文件。

X:\Program Files\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\Templates

997755.com澳门葡京,X:\Program Files\Microsoft SQL
Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
注:以上“X:\Program Files\Microsoft SQL Server”为SQL
Server的设置目录。以下的“C:\Program Files\Microsoft SQL
Server”为系统盘下的目录

  • 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

2、定位并执行安装命令

 

首先找到安装命令:
C:\Program Files\Microsoft SQL Server\100\Setup
Bootstrap\Release\setup.exe

参见:

如若只是Windows身份验证情势,只需求如下语法就可以:
setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=<instance name>
/SQLSYSADMINACCOUNTS=<accounts> 
万一是复合身份验证格局,则须要利用/SAPWD参数提供sa的密码:
setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=<instance name>
/SQLSYSADMINACCOUNTS=<accounts> /SAPWD=<sa password>

 

自家设置时设置的是复合认证情势,SQL
Server系统管理员帐号是administrators组,sa密码是123456。并且就贰个默许实例:MSSQLSEWranglerVE奥迪Q7。
为此在命令行实施如下命令:
setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER
/SQLSYSADMINACCOUNTS=administrators /SAPWD=123456

 

试行完结后未有别的提醒消息(不管成功与否),然而足以立时在C:\Program
Files\Microsoft SQL Server\100\Setup
Bootstrap\Log\Summary.txt中查阅安装日志。

 

终极,在Sql Server Configuration Manager中运营SQL Server服务成功。

相关文章

发表评论

电子邮件地址不会被公开。 必填项已用*标注

*
*
Website