Monday, March 19, 2012

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...
> > 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.
> >
>
>

No comments:

Post a Comment