backup problems error 3202

Hello
We are currently having problems backing in a full backup into maintenance
plan all days, we have this error in log file:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL
Server Driver][SQL Server] write failure in
'E:\backupsql\ECASH_db_200507120652.BAK', state = 121
When I try that in the morning, ( executed manually) the result is ok
Any help would be appreciated.
Hi,
THis type of issue come when there is some hardware issues (RAID). Can you
ask your hardware vendor to run the diagonostic checks
to verify if there is any issue.
Thanks
Hari
SQL Server MVP
"santi" <santi@.discussions.microsoft.com> wrote in message
news:811568D0-F68E-4780-9E57-2661AEEC1FA4@.microsoft.com...
> Hello
> We are currently having problems backing in a full backup into maintenance
> plan all days, we have this error in log file:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server] write failure in
> 'E:\backupsql\ECASH_db_200507120652.BAK', state = 121
> When I try that in the morning, ( executed manually) the result is ok
> Any help would be appreciated.
>
|||Hi
I think this answer is in the correct way, because we have in our server a
RAID system. I will try contact with hardware vendor for disk test, but I
don,t understand why in automatic mode we have error and in manual mode we
don,t have error. Do you understand?
Thank you
"Hari Prasad" escribió:

> Hi,
> THis type of issue come when there is some hardware issues (RAID). Can you
> ask your hardware vendor to run the diagonostic checks
> to verify if there is any issue.
> Thanks
> Hari
> SQL Server MVP
>
> "santi" <santi@.discussions.microsoft.com> wrote in message
> news:811568D0-F68E-4780-9E57-2661AEEC1FA4@.microsoft.com...
>
>

Backup ODBC on Windows 2000 Server?

howto backup ODBC configure and data on windows 2000 server help me!
thanks.urr?
Are you wanting to backup SQL Server?
Are you wanting to backup any data that you can find an ODBC driver for (that would be fun)?
Are you wanting to confuse me?|||If you want to backup the ODBC configuration of the server, including its ODBC drivers, DSNs, FSNs, etc, make a full backup of the whole server. Although it is possible to "clone" the ODBC configuration onto a new server, that is not a wise idea.

-PatP|||ODBC configuration is kept in registry which is what you need to back up.|||ODBC configuration is kept in registry which is what you need to back up.Yes, and restoring a registry onto another machine has always been a reciepe for disaster in my book. Even doing selected hives or even keys is dangerous unless the destination machine has EVERYTHING referenced in the source machine!

-PatP|||OK, who pissed Pat off?? Raise your hand!|||Sorry if I sound testy, I certainly didn't mean that. The problem with telling someone that isn't very familiar with the registry to do much of anything with it, is that there is huge risk.

Based on the question, my guess is that they aren't familiar with the even what the registry is, much less how to work on it. If they wipe out a hive (yes, I've seen that done!), they can make a machine unbootable. That's pretty risky stuff, just to save 5 minutes of ODBC setup.

Even if they just have the wrong MDAC or Oracle version, that can make it useless to restore the DSNs from one machine to another. I guess that I've had to fix too many machines where someone was trying to save five minutes and it cost me a day of travel and three hours worth of work.

-PatP

backup log terminated abormally

I backup the transaction log unsuccessfully.
It pops up :
Error Box Title : Microsoft SQL-DMO(ODBC SQLState 42000)
DetailMessgae : Write
on 'c:\MSSQL\Backup\mydata_db_2004043.BAK' failed, status
=112.
Has anyone experienced this before or knows what is
going wrong ?You can type 'NET HELPMSG 112' from a command prompt window to get the
following Windows error message text:
There is not enough space on the disk.
Try the backup again after freeing some disk space.
Hope this helps.
Dan Guzman
SQL Server MVP
"Newbie" <anonymous@.discussions.microsoft.com> wrote in message
news:618b01c481ad$b566e040$a401280a@.phx.gbl...
> I backup the transaction log unsuccessfully.
> It pops up :
> Error Box Title : Microsoft SQL-DMO(ODBC SQLState 42000)
> DetailMessgae : Write
> on 'c:\MSSQL\Backup\mydata_db_2004043.BAK' failed, status
> =112.
> Has anyone experienced this before or knows what is
> going wrong ?
>|||Thanks Dan for the answers...

>--Original Message--
>You can type 'NET HELPMSG 112' from a command prompt
window to get the
>following Windows error message text:
> There is not enough space on the disk.
>Try the backup again after freeing some disk space.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Newbie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:618b01c481ad$b566e040$a401280a@.phx.gbl...
42000)[vbcol=seagreen]
status[vbcol=seagreen]
>
>.
>

backup log terminated abormally

I backup the transaction log unsuccessfully.
It pops up :
Error Box Title : Microsoft SQL-DMO(ODBC SQLState 42000)
DetailMessgae : Write
on 'c:\MSSQL\Backup\mydata_db_2004043.BAK' failed, status
=112.
Has anyone experienced this before or knows what is
going wrong ?
You can type 'NET HELPMSG 112' from a command prompt window to get the
following Windows error message text:
There is not enough space on the disk.
Try the backup again after freeing some disk space.
Hope this helps.
Dan Guzman
SQL Server MVP
"Newbie" <anonymous@.discussions.microsoft.com> wrote in message
news:618b01c481ad$b566e040$a401280a@.phx.gbl...
> I backup the transaction log unsuccessfully.
> It pops up :
> Error Box Title : Microsoft SQL-DMO(ODBC SQLState 42000)
> DetailMessgae : Write
> on 'c:\MSSQL\Backup\mydata_db_2004043.BAK' failed, status
> =112.
> Has anyone experienced this before or knows what is
> going wrong ?
>
|||Thanks Dan for the answers...

>--Original Message--
>You can type 'NET HELPMSG 112' from a command prompt
window to get the
>following Windows error message text:
> There is not enough space on the disk.
>Try the backup again after freeing some disk space.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Newbie" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:618b01c481ad$b566e040$a401280a@.phx.gbl...
42000)[vbcol=seagreen]
status
>
>.
>

backup log terminated abormally

I backup the transaction log unsuccessfully.
It pops up :
Error Box Title : Microsoft SQL-DMO(ODBC SQLState 42000)
DetailMessgae : Write
on 'c:\MSSQL\Backup\mydata_db_2004043.BAK' failed, status
=112.
Has anyone experienced this before or knows what is
going wrong ?You can type 'NET HELPMSG 112' from a command prompt window to get the
following Windows error message text:
There is not enough space on the disk.
Try the backup again after freeing some disk space.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Newbie" <anonymous@.discussions.microsoft.com> wrote in message
news:618b01c481ad$b566e040$a401280a@.phx.gbl...
> I backup the transaction log unsuccessfully.
> It pops up :
> Error Box Title : Microsoft SQL-DMO(ODBC SQLState 42000)
> DetailMessgae : Write
> on 'c:\MSSQL\Backup\mydata_db_2004043.BAK' failed, status
> =112.
> Has anyone experienced this before or knows what is
> going wrong ?
>|||Thanks Dan for the answers...
>--Original Message--
>You can type 'NET HELPMSG 112' from a command prompt
window to get the
>following Windows error message text:
> There is not enough space on the disk.
>Try the backup again after freeing some disk space.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Newbie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:618b01c481ad$b566e040$a401280a@.phx.gbl...
>> I backup the transaction log unsuccessfully.
>> It pops up :
>> Error Box Title : Microsoft SQL-DMO(ODBC SQLState
42000)
>> DetailMessgae : Write
>> on 'c:\MSSQL\Backup\mydata_db_2004043.BAK' failed,
status
>> =112.
>> Has anyone experienced this before or knows what is
>> going wrong ?
>>
>
>.
>

backup have error!Status=112.................plx help!thank you

Hello!
when i did the backup job for SQL Server, have below error message,plx help
me for more informations.
Microsoft SQL-DMO(ODBC SQLState:42000)
Write on 'c:\mssql7\backup\zggf0806' failed, status = 112, see the SQL
Server error log for more details. Backup or restore operation terminating
abnormally..............
i think the status=112 it is not haven't enough spaces for the disk, because
the disk have enough free spaces.
plx tell me what will i do'
thank you very much!Have you seen
http://support.microsoft.com/default.aspx?scid=kb;en-
us;325334
You will also need to free up some disk space, try getting
rid of old backups
Peter
>--Original Message--
>Hello!
>when i did the backup job for SQL Server, have below
error message,plx help
>me for more informations.
>Microsoft SQL-DMO(ODBC SQLState:42000)
>Write on 'c:\mssql7\backup\zggf0806' failed, status =112, see the SQL
>Server error log for more details. Backup or restore
operation terminating
>abnormally..............
>
>i think the status=112 it is not haven't enough spaces
for the disk, because
>the disk have enough free spaces.
>plx tell me what will i do'
>
>thank you very much!
>
>.
>|||How big is your database and how much free space do you have on Drive C ?
--
--
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Genius W.H. Chow" <genius-sendmoreinfo@.21cn.com> wrote in message
news:en15Ul5eEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Hello!
> when i did the backup job for SQL Server, have below error message,plx
help
> me for more informations.
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Write on 'c:\mssql7\backup\zggf0806' failed, status = 112, see the SQL
> Server error log for more details. Backup or restore operation terminating
> abnormally..............
>
> i think the status=112 it is not haven't enough spaces for the disk,
because
> the disk have enough free spaces.
> plx tell me what will i do'
>
> thank you very much!
>
>