Tuesday, March 20, 2012

Backup Device error or device off-line.

I received the error message listed below when the SQL
Server backup maintenance job runs daily. The server was
Windows 2000 Advanced Server with SQL Server 2000
Enterprise Edition and SP3. I can backup the database
manually with SQL Server in the same directory without a
problem.
Please help me resolve this issue.
Thanks,
Dan
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
backup device 'K:\MARKDEV_db_200406160300.BAK'. Device
error or device off-line. See the SQL Server error log for
more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY
DATABASE is terminating abnormally.Hi,
Can you check the Windows Event viwer application log for more errors.
Hopefully you will get more explanation of this error there.
Is this K drive a local drive or remote drive? If it is remote drive then
start the SQLServerAgent service using
a domain account with write access to Kdrive
Thanks
Hari
MCDBA
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:1d3fc01c453a1$f0edc190$a401280a@.phx.gbl...
> I received the error message listed below when the SQL
> Server backup maintenance job runs daily. The server was
> Windows 2000 Advanced Server with SQL Server 2000
> Enterprise Edition and SP3. I can backup the database
> manually with SQL Server in the same directory without a
> problem.
> Please help me resolve this issue.
> Thanks,
> Dan
>
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
> backup device 'K:\MARKDEV_db_200406160300.BAK'. Device
> error or device off-line. See the SQL Server error log for
> more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY
> DATABASE is terminating abnormally.
>

No comments:

Post a Comment