SQL Server detected a logical consistency-based I/

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server detected a logical consistency-based I/

Author

Topic

dba123
Yak Posting Veteran

90 Posts

Posted - 2008-03-16 : 22:25:45

This local test DB was doing just fine. I fire up SQL Server again, and all of a sudden I can't access it (expend the database in Management Studio). So I detach and try to run this script which was run initially to re-attach it:

USE [master]
GO
CREATE DATABASE [ABS] ON
( FILENAME = N'C:\Database\ABS.mdf' ),
( FILENAME = N'C:\Database\ABS_log.ldf' )
FOR ATTACH
GO
if not exists (select name from master.sys.databases sd where name = N'CMS' and SUSER_SNAME(sd.owner_sid) = SUSER_SNAME() ) EXEC [CMS].dbo.sp_changedbowner @loginame=N'domain\testuser', @map=false
GO

and I get this error: SQL Server detected a logical consistency-based I/O error: torn page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-16 : 22:39:10

You need restore from good backup I believe. If you didn't detach it, maybe able to fix the problem with dbcc.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources