Friday, February 24, 2012

Drive Dying - how to rescue SQL

Hi All,
I have sql 2000 on Win 2003.
I think my drive is dying (once I got in to work and machine was dead and
drive check showed a lot of errors)
Anyways, now I am having problems backup up certain SQL db's (in order to
make the log smaller again).
I get the error
Nonrecoverable I/O error occured on file c:\.......\xxxx.LDF
BACKUP LOG is terminating abnormally
As I cannot backup the databases, where do I go from here?tony wrote:

> Hi All,
> I have sql 2000 on Win 2003.
> I think my drive is dying (once I got in to work and machine was dead and
> drive check showed a lot of errors)
> Anyways, now I am having problems backup up certain SQL db's (in order to
> make the log smaller again).
> I get the error
> Nonrecoverable I/O error occured on file c:\.......\xxxx.LDF
> BACKUP LOG is terminating abnormally
> As I cannot backup the databases, where do I go from here?
Try to copy mdf and ldf on other PC
Later on you can attach them.
Regards
Amish Shah
http://shahamishm.tripod.com|||If the worst comes I have used a utiltity from http://www.runtime.org/
called GetBack for NTFS that does an excellent job of getting data off of
drives. When Windows reads bad drives it only puts in so much effort then
quits, but this program tries to get every readable piece of data off the
drive. If somenthing screws up the partition table or directories Windows
will not be able to read the drive. As long and the electronic are OK on
the drive and the platters move GetBack can get data off by looking at the
drive block by block and recreating a file system.
This is not all that simple to use because it even recovers deleted files or
moved files so sometimes you can see multiple saved versions of the same
file. Most of the time it is pretty clear which file you need to get off
and the ones that are not recoverable are old delete files anyway.
"amish" <shahamishm@.gmail.com> wrote in message
news:1155895549.783867.146780@.h48g2000cwc.googlegroups.com...
> tony wrote:
>
> Try to copy mdf and ldf on other PC
> Later on you can attach them.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Hi,
First verify free space in each of your databases (use enterprise manager --
click the database-- view taskpad view. If you have more free space
try to shrink the file. This will give you some extra space to backup. Once
you are done with the backup; then Add a
new drive the server and do:-
1. Detach the databases which grows heavily (See SP_detach_db)
2. Move the MDF and LDF to new drive
3. Attach the database (See SP_Attach_db from books online)
Thanks
Hari
SQL Server MVP
"tony" <tonyds@.nospam.mailbox.co.za> wrote in message
news:ec42oh$nr8$1@.ctb-nnrp2.saix.net...
> Hi All,
> I have sql 2000 on Win 2003.
> I think my drive is dying (once I got in to work and machine was dead and
> drive check showed a lot of errors)
> Anyways, now I am having problems backup up certain SQL db's (in order to
> make the log smaller again).
> I get the error
> Nonrecoverable I/O error occured on file c:\.......\xxxx.LDF
> BACKUP LOG is terminating abnormally
> As I cannot backup the databases, where do I go from here?
>
>

No comments:

Post a Comment