sql server 2008 R2 Error 9003:The log scan number passed to log scan in database is not valid
来源:互联网 发布:linux vim 查看头文件 编辑:程序博客网 时间:2024/05/18 07:22
服务器突然断电,导致SQL Server 2008 R2突然死掉,attach database 时提示9003错误,
错误原因:ldf文件或者mdf文件出错,极有可能是ldf在备份操作时和mdf不同步
解决方法:重新根据mdf生成一个新的ldf;新建一个同名的数据库,停掉SQL Server服务,删除ldf文件,把需要修复的mdf文件覆盖掉新建的mdf文件,启动SQL Server服务,执行下面语句:
/*设置数据库允许直接操作系统表*/
use master
go
exec sp_configure 'allow updates',1
go
reconfigure with override
go
/*设置为紧急修复模式*/
alter database YourDatabase set emergency
go
alter database YourDatabase set single_user with rollback immediate
go
alter database nocloneweb Rebuild Log on (name=nocloneweb_1,filename= 'J:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\YourDatabase.ldf')
alter database nocloneweb set multi_user
- sql server 2008 R2 Error 9003:The log scan number passed to log scan in database is not valid
- Restore SQL Server 2005 error : "The tail of the log for the database "TEST1" has not been backed up."
- 51 You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the
- The transaction log for database 'NJ_Address' is full. To find out why space in the log cannot be
- SQL Server 2008 R2 Update语句log
- [Error Fix] The transaction log for database 'DATABASENAME' is full
- SQL Server 2008 R2 安装程序 Upgrade Failed due to the following Error.The error code is :-2147467259.Mes
- why the redo log is not needed to backup in the RMAN backup?
- Path to log file not valid: log/mongrel.log问题
- Steps to change the default location of SQL Server /SQL Server Agent - Error log files
- What is SCAN in Oracle 11g R2 RAC
- TIP: when you get a message in job log user [Dr. Who] is not authorized to view the log
- SQL to clear database log
- How to determine SQL Server database transaction log usage
- psql: FATAL: role "root" is not permitted to log in
- InnoDB: The log sequence number in ibdatafiles does not match the log sequence number in the ib_log
- server 2 task(s) are sleeping waiting for space to become available in the log segment for database tempdb.
- The log file for database '' is full
- vlc 编译过程留底
- javascript高级
- 笔记2:Singleton 单件(创建型模式)
- 桌面程序显示位置
- MFC动态创建控件及添加消息响应
- sql server 2008 R2 Error 9003:The log scan number passed to log scan in database is not valid
- ASP.NET 网站路径
- Android系统的Socket多线程编程实例
- Linux ssh 下的简单 IM 通信
- sscanf,sscanf_s及其相关用法
- 开发实现ArcScene和ArcGlobe由书签创建关键帧
- date time server&client
- Linux下avr单片机开发环境
- Image is Everuthing LA2995