How to repair torn page on SQL data file?

ann han

I got help from Dan Guzman on how to set single-user-mode.
Thank you very much.

After seting single-user-mode, I run DBCC CHECKDB
('MYDATABASE',REPAIR_REBUILD)
Tehre are error messages.
How can I repair torn page problem?
Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #1

Subscribe Post Reply

8590

Dan Guzman

What error messages are you getting?

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"ann han" <an*****@yahoo.com> wrote in message
news:3f***********************@news.frii.net...

I got help from Dan Guzman on how to set single-user-mode.
Thank you very much.

After seting single-user-mode, I run DBCC CHECKDB
('MYDATABASE',REPAIR_REBUILD)
Tehre are error messages.
How can I repair torn page problem?
Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #2

Similar topics

Err. 823 Torn Page Detected

by: Chandika | last post by:

Hi all, One of my database was suspected, So I try to recover database then it gives this error Err. 823 Torn Page Detected 823, ... 24, spid51 i/o error Torn Page (Detected) during read...

Microsoft SQL Server

how data file and log file grow?

by: Bing Du | last post by:

Greetings, The following shows how the Properties of a database look like: Data Files: File Name: student_dat Location: e:\data\MSSQL\Data\student.mdf Space allocated (MB): 62...

Microsoft SQL Server

Torn page error

by: Prashant Thakwani | last post by:

I am getting the following error message while attaching my DB in SQL Server 2000. "Error 823:I/O error ( torn page) detected during read at offset 0x000000000026000 in file 'C:\TestFile.MDF.' ...

Microsoft SQL Server

repair torn page?

by: bbbad_999 | last post by:

I have inherited a poorly administered/maintained database that contains the following error: "I/O error (torn page) detected during read at offset 0x000018ee23e000 in file 'F:\Program...

Microsoft SQL Server

Torn Page

by: jennifer1970 | last post by:

Hi all. I'm getting an error mssage which tells me I have a torn page: ODBC error 823 (HY000) I/O error (torn page) detected during read at offset 0x00000080b5c000 in file 'D:\WINSUPPORTDATA\Win...

Microsoft SQL Server

torn page detection and auto shrink: performance?

by: Matik | last post by:

Hello everybody, First: SQL Server 2000 sp3a, HP cluster server, MS 2003 server, database recovery model simple Torn page detection: When I have this option turned on, processes conected with...

Microsoft SQL Server

Torn page problem

by: David Greenberg | last post by:

Hi When trying to create an SqlServer job, clicking OK' I got the message "Error 823: I/O error (torn page) detected during read at offset..... in file 'd:\sqlserver\MSSQL\data\msdata.mdf'. The...

Microsoft SQL Server

Recurring data file corruption leading to my insanity

by: nepdae | last post by:

Please forgive me, this is a long one. My 11-user Access 2000 database is having recurring corruption problems. The symptoms include the following: 1) corrupted fields in recently created or...

Microsoft Access / VBA

save a flat export data file as an excel file

by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:

Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this...

ASP / Active Server Pages

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++