问:迁移后数据库不能启动,迁移后数据库不能启动
答:您好,非常抱歉,本次已经特殊检查,核实启动sqlserver提示sqlservr.exe文件有异常,查看D:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Log下的错误日志记录如下,尝试把正常的mssql的启动程序sqlservr.exe 和mssqlsystemresource.mdf这个有问题的系统数据库文件替换后,测试启动mssql数据库成功了,请您重新试试,,非常感谢您长期对我司的支持!
21:25:44.34 spid7s SQL Server detected a logical consistency-based I/O error: 校验和不正确(应为: 0x2540a350,但实际为: 0xaf592bc3). It occurred during a 读取 of page (1:0) in database ID 32767 at offset in file 'D:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Binn\\mssqlsystemresource.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
21:25:44.34 spid7s 错误: 945,严重性: 14,状态: 2。
21:25:44.34 spid7s 由于文件不可访问,或者内存或磁盘空间不足,所以无法打开数据库 'mssqlsystemresource'。有关详细信息,请参阅 SQL Server 错误日志。
21:25:44.34 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
问:数据库不能启动!!!
问:请问什么时候可以处理好??!!!
答:您好,已经正常启动好了,现在可正常访问了,非常感谢您长期对我司的支持!
问:
http://bbs.yilongnews.com/
网站不能打开!!!
又出现 同样的问题了!!!!
答:您好,已经处理好了,您修改数据库版本为5.6,但没有进行数据库同步,这样5.6的数据库下就没有对应的网站论坛的管理账号,现在同步了,已经正常,请测试,谢谢
此次特殊帮您处理,以后对应问题,请提交对应的工单分类,谢谢配合