Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Torn Page Detection during Recovery

Status
Not open for further replies.
saint8

saint8

Programmer
Joined
Feb 5, 2001
Messages
1
Location
GB
While executing an update procedure, power was lost to the server. The resultant re-boot initiated the recovery procedure - a torn page error was encountered while reading one of the main .mdf files.
Is there any way of repairing the database without using a restore as the latest backup is over a week out of date.
 
Sort by date Sort by votes
Have you tried running DBCC CHECKDB using the repair options.

Rick.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Virendra Yaduvanshi
  • Locked
  • Question Question
SSRS - Subscription page error
Replies
0
Views
541
Virendra Yaduvanshi
Virendra Yaduvanshi
BxWill
  • Locked
  • Question Question
Unpivot during Bulk Insert
Replies
5
Views
277
Andrzejek
Andrzejek
vba317
  • Locked
  • Question Question
Ttrying to add an id number to table during insert with no luck
Replies
6
Views
155
Olaf Doschke
Olaf Doschke
BrooksMT
  • Locked
  • Question Question
Showing times at key points during a SQL script
Replies
4
Views
212
BrooksMT
BrooksMT
tshad
  • Locked
  • Question Question
Accessing Property in master page prevents controls from being created
Replies
2
Views
156
SQLBill
SQLBill

Part and Inventory Search

Sponsor

Back
Top