I'm getting this error and I don't know where to begin. Our environment is
SQL Server 2000 sp3a on Win Server 2003.
I get the error when running an insert statement in a sql job that executes
as the admin. The insert is a simple one from one table to another.
Ultimately, I need to insert from a VIEW that is set up w/ a linked server
pulling data from FoxPro.
Here is the error message:
Executed as user: DOMAIN\admin. The operation could not be performed because
the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction.
[SQLSTATE 42000] (Error 7391) Driver not capable] [SQLSTATE 01000] (Error
7312) OLE DB error trace [OLE/DB Provider 'MSDASQL'
ITransactionJoin::JoinTransaction returned 0x8004d00a]. [SQLSTATE 01000]
(Error 7300). The step failed.
I made a change a few days ago to resolve a memory issue. The change was I
disabled Allow InProcess on the OLE DB for ODBC Drivers provider. Doesn't
seem like this error would be related and I haven't been able to prove
otherwise when enabling the option, for instance.
Any help is appreciated. Thank you, PhilNo resolution yet but I believe the problem is in a trigger on the table I a
m
inserting to. The trigger has sql code that uses views built on a linked
server getting data from foxpro.
"phil" wrote:
> I'm getting this error and I don't know where to begin. Our environment i
s
> SQL Server 2000 sp3a on Win Server 2003.
> I get the error when running an insert statement in a sql job that execute
s
> as the admin. The insert is a simple one from one table to another.
> Ultimately, I need to insert from a VIEW that is set up w/ a linked server
> pulling data from FoxPro.
> Here is the error message:
> Executed as user: DOMAIN\admin. The operation could not be performed becau
se
> the OLE DB provider 'MSDASQL' was unable to begin a distributed transactio
n.
> [SQLSTATE 42000] (Error 7391) Driver not capable] [SQLSTATE 01000] (Error
> 7312) OLE DB error trace [OLE/DB Provider 'MSDASQL'
> ITransactionJoin::JoinTransaction returned 0x8004d00a]. [SQLSTATE 01000]
> (Error 7300). The step failed.
> I made a change a few days ago to resolve a memory issue. The change was
I
> disabled Allow InProcess on the OLE DB for ODBC Drivers provider. Doesn't
> seem like this error would be related and I haven't been able to prove
> otherwise when enabling the option, for instance.
> Any help is appreciated. Thank you, Phil
Showing posts with label win. Show all posts
Showing posts with label win. Show all posts
Sunday, February 26, 2012
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?
>
>
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?
>
>
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:
>> 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
>|||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?
>
>
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:
>> 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
>|||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?
>
>
Subscribe to:
Posts (Atom)