backup exec fails (though having the sql addon)

Hi group
Working with backup exec 10, sql agent and advanced open file options
included to backup our databases. We have 11 SQL databases varying in size
from 200 to 5000mb. There is one new dbase which is the database for a
website that is now not being backed up (size, approx 1.5 GB), this has
never worked since it was created last week.
(for now we are doing a full backup dump in non production hours to a
location that is backed up)
Additional info:
-Backupexec runs under a domain admin account
-SQL Server runs under another account
-owner for databases is domain admin
-2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
-backupexec shows fileskipped messages without specifying the file
-no usable info in eventvwr
-there are jobs running on this database (although not when the backup is
run)
-no locks/active connections are shown in the enterprise manager
Are there any issues with sql databases that are used by websites?
Has anybody have experienced similar problems and have a sollution available
that might work for me?
thx.
PerryPerry,
When you view the history for the backup job with BackupExec what error
message is recorded, if any?
> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
Using? Are you using Enterprise Manager? If not, does that work? Any
errors in the SQL errorlog for the backup failing?
HTH
Jerry
"Perry" <reply@.to.ng> wrote in message
news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Hi group
> Working with backup exec 10, sql agent and advanced open file options
> included to backup our databases. We have 11 SQL databases varying in size
> from 200 to 5000mb. There is one new dbase which is the database for a
> website that is now not being backed up (size, approx 1.5 GB), this has
> never worked since it was created last week.
> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
> Additional info:
> -Backupexec runs under a domain admin account
> -SQL Server runs under another account
> -owner for databases is domain admin
> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
> -backupexec shows fileskipped messages without specifying the file
> -no usable info in eventvwr
> -there are jobs running on this database (although not when the backup is
> run)
> -no locks/active connections are shown in the enterprise manager
> Are there any issues with sql databases that are used by websites?
> Has anybody have experienced similar problems and have a sollution
> available that might work for me?
> thx.
> Perry
>
>|||Hi
Never use open file options against a SQL Server database as the DB and
Transaction log will never be restorable as they will not be in sync at a
point in time.
Backup the database to disk from within SQL Server (see BACKUP command in
BOL), or use the SQL Server maintenance wizard.
Backup the backup file files that SQL Server generated.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Perry" <reply@.to.ng> wrote in message
news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Hi group
> Working with backup exec 10, sql agent and advanced open file options
> included to backup our databases. We have 11 SQL databases varying in size
> from 200 to 5000mb. There is one new dbase which is the database for a
> website that is now not being backed up (size, approx 1.5 GB), this has
> never worked since it was created last week.
> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
> Additional info:
> -Backupexec runs under a domain admin account
> -SQL Server runs under another account
> -owner for databases is domain admin
> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
> -backupexec shows fileskipped messages without specifying the file
> -no usable info in eventvwr
> -there are jobs running on this database (although not when the backup is
> run)
> -no locks/active connections are shown in the enterprise manager
> Are there any issues with sql databases that are used by websites?
> Has anybody have experienced similar problems and have a sollution
> available that might work for me?
> thx.
> Perry
>
>|||Mike,
I have this same argument with my IT director. It's been one of those he
won't budge...I won't budge thing so...Veritas does have an agent for SQL
backups. We have the license but I've chosen not to use it (yet) not
because it doesn't work but because it is a bit more challenging and
involved. I do backup the databases using EM (jobs) then I use Veritas
BackupExec to backup the backup files to tape for off-site storage.
HTH
Jerry
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ObMOEeVxFHA.3756@.tk2msftngp13.phx.gbl...
> Hi
> Never use open file options against a SQL Server database as the DB and
> Transaction log will never be restorable as they will not be in sync at a
> point in time.
> Backup the database to disk from within SQL Server (see BACKUP command in
> BOL), or use the SQL Server maintenance wizard.
> Backup the backup file files that SQL Server generated.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Perry" <reply@.to.ng> wrote in message
> news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
>> Hi group
>> Working with backup exec 10, sql agent and advanced open file options
>> included to backup our databases. We have 11 SQL databases varying in
>> size from 200 to 5000mb. There is one new dbase which is the database for
>> a website that is now not being backed up (size, approx 1.5 GB), this has
>> never worked since it was created last week.
>> (for now we are doing a full backup dump in non production hours to a
>> location that is backed up)
>> Additional info:
>> -Backupexec runs under a domain admin account
>> -SQL Server runs under another account
>> -owner for databases is domain admin
>> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
>> -backupexec shows fileskipped messages without specifying the file
>> -no usable info in eventvwr
>> -there are jobs running on this database (although not when the backup is
>> run)
>> -no locks/active connections are shown in the enterprise manager
>> Are there any issues with sql databases that are used by websites?
>> Has anybody have experienced similar problems and have a sollution
>> available that might work for me?
>> thx.
>> Perry
>>
>>
>|||Jerry,
Below is what the log says, the servername is DC4, the databasename is
SYNERGY:
Job Completion Status
Job ended: Wednesday, September 28, 2005 at 8:36:41 PM
Completed status: Completed with exceptions
Errors
Click an error below to locate it in the job log
Backup- DC4 Database ?SYNERGY was not found, or could not be accessed.
Exceptions
Click an exception below to locate it in the job log
Backup- DC4 The item DC4\SYNERGY in use - skipped.Perry
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:u4j16tUxFHA.3740@.tk2msftngp13.phx.gbl...
> Perry,
> When you view the history for the backup job with BackupExec what error
> message is recorded, if any?
>> (for now we are doing a full backup dump in non production hours to a
>> location that is backed up)
> Using? Are you using Enterprise Manager? If not, does that work? Any
> errors in the SQL errorlog for the backup failing?
> HTH
> Jerry
> "Perry" <reply@.to.ng> wrote in message
> news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
>> Hi group
>> Working with backup exec 10, sql agent and advanced open file options
>> included to backup our databases. We have 11 SQL databases varying in
>> size from 200 to 5000mb. There is one new dbase which is the database for
>> a website that is now not being backed up (size, approx 1.5 GB), this has
>> never worked since it was created last week.
>> (for now we are doing a full backup dump in non production hours to a
>> location that is backed up)
>> Additional info:
>> -Backupexec runs under a domain admin account
>> -SQL Server runs under another account
>> -owner for databases is domain admin
>> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
>> -backupexec shows fileskipped messages without specifying the file
>> -no usable info in eventvwr
>> -there are jobs running on this database (although not when the backup is
>> run)
>> -no locks/active connections are shown in the enterprise manager
>> Are there any issues with sql databases that are used by websites?
>> Has anybody have experienced similar problems and have a sollution
>> available that might work for me?
>> thx.
>> Perry
>>
>>
>

backup exec fails (though having the sql addon)

Hi group
Working with backup exec 10, sql agent and advanced open file options
included to backup our databases. We have 11 SQL databases varying in size
from 200 to 5000mb. There is one new dbase which is the database for a
website that is now not being backed up (size, approx 1.5 GB), this has
never worked since it was created last week.
(for now we are doing a full backup dump in non production hours to a
location that is backed up)
Additional info:
-Backupexec runs under a domain admin account
-SQL Server runs under another account
-owner for databases is domain admin
-2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
-backupexec shows fileskipped messages without specifying the file
-no usable info in eventvwr
-there are jobs running on this database (although not when the backup is
run)
-no locks/active connections are shown in the enterprise manager
Are there any issues with sql databases that are used by websites?
Has anybody have experienced similar problems and have a sollution available
that might work for me?
thx.
Perry
Perry,
When you view the history for the backup job with BackupExec what error
message is recorded, if any?

> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
Using? Are you using Enterprise Manager? If not, does that work? Any
errors in the SQL errorlog for the backup failing?
HTH
Jerry
"Perry" <reply@.to.ng> wrote in message
news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Hi group
> Working with backup exec 10, sql agent and advanced open file options
> included to backup our databases. We have 11 SQL databases varying in size
> from 200 to 5000mb. There is one new dbase which is the database for a
> website that is now not being backed up (size, approx 1.5 GB), this has
> never worked since it was created last week.
> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
> Additional info:
> -Backupexec runs under a domain admin account
> -SQL Server runs under another account
> -owner for databases is domain admin
> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
> -backupexec shows fileskipped messages without specifying the file
> -no usable info in eventvwr
> -there are jobs running on this database (although not when the backup is
> run)
> -no locks/active connections are shown in the enterprise manager
> Are there any issues with sql databases that are used by websites?
> Has anybody have experienced similar problems and have a sollution
> available that might work for me?
> thx.
> Perry
>
>
|||Hi
Never use open file options against a SQL Server database as the DB and
Transaction log will never be restorable as they will not be in sync at a
point in time.
Backup the database to disk from within SQL Server (see BACKUP command in
BOL), or use the SQL Server maintenance wizard.
Backup the backup file files that SQL Server generated.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Perry" <reply@.to.ng> wrote in message
news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Hi group
> Working with backup exec 10, sql agent and advanced open file options
> included to backup our databases. We have 11 SQL databases varying in size
> from 200 to 5000mb. There is one new dbase which is the database for a
> website that is now not being backed up (size, approx 1.5 GB), this has
> never worked since it was created last week.
> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
> Additional info:
> -Backupexec runs under a domain admin account
> -SQL Server runs under another account
> -owner for databases is domain admin
> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
> -backupexec shows fileskipped messages without specifying the file
> -no usable info in eventvwr
> -there are jobs running on this database (although not when the backup is
> run)
> -no locks/active connections are shown in the enterprise manager
> Are there any issues with sql databases that are used by websites?
> Has anybody have experienced similar problems and have a sollution
> available that might work for me?
> thx.
> Perry
>
>
|||Mike,
I have this same argument with my IT director. It's been one of those he
won't budge...I won't budge thing so...Veritas does have an agent for SQL
backups. We have the license but I've chosen not to use it (yet) not
because it doesn't work but because it is a bit more challenging and
involved. I do backup the databases using EM (jobs) then I use Veritas
BackupExec to backup the backup files to tape for off-site storage.
HTH
Jerry
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ObMOEeVxFHA.3756@.tk2msftngp13.phx.gbl...
> Hi
> Never use open file options against a SQL Server database as the DB and
> Transaction log will never be restorable as they will not be in sync at a
> point in time.
> Backup the database to disk from within SQL Server (see BACKUP command in
> BOL), or use the SQL Server maintenance wizard.
> Backup the backup file files that SQL Server generated.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Perry" <reply@.to.ng> wrote in message
> news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
>
|||Jerry,
Below is what the log says, the servername is DC4, the databasename is
SYNERGY:
Job Completion Status
Job ended: Wednesday, September 28, 2005 at 8:36:41 PM
Completed status: Completed with exceptions
Errors
Click an error below to locate it in the job log
Backup- DC4 Database ?SYNERGY was not found, or could not be accessed.
Exceptions
Click an exception below to locate it in the job log
Backup- DC4 The item DC4\SYNERGY in use - skipped.Perry
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:u4j16tUxFHA.3740@.tk2msftngp13.phx.gbl...
> Perry,
> When you view the history for the backup job with BackupExec what error
> message is recorded, if any?
>
> Using? Are you using Enterprise Manager? If not, does that work? Any
> errors in the SQL errorlog for the backup failing?
> HTH
> Jerry
> "Perry" <reply@.to.ng> wrote in message
> news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
>

backup exec fails (though having the sql addon)

Hi group
Working with backup exec 10, sql agent and advanced open file options
included to backup our databases. We have 11 SQL databases varying in size
from 200 to 5000mb. There is one new dbase which is the database for a
website that is now not being backed up (size, approx 1.5 GB), this has
never worked since it was created last week.
(for now we are doing a full backup dump in non production hours to a
location that is backed up)
Additional info:
-Backupexec runs under a domain admin account
-SQL Server runs under another account
-owner for databases is domain admin
-2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
-backupexec shows fileskipped messages without specifying the file
-no usable info in eventvwr
-there are jobs running on this database (although not when the backup is
run)
-no locks/active connections are shown in the enterprise manager
Are there any issues with sql databases that are used by websites?
Has anybody have experienced similar problems and have a sollution available
that might work for me?
thx.
PerryPerry,
When you view the history for the backup job with BackupExec what error
message is recorded, if any?

> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
Using? Are you using Enterprise Manager? If not, does that work? Any
errors in the SQL errorlog for the backup failing?
HTH
Jerry
"Perry" <reply@.to.ng> wrote in message
news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Hi group
> Working with backup exec 10, sql agent and advanced open file options
> included to backup our databases. We have 11 SQL databases varying in size
> from 200 to 5000mb. There is one new dbase which is the database for a
> website that is now not being backed up (size, approx 1.5 GB), this has
> never worked since it was created last week.
> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
> Additional info:
> -Backupexec runs under a domain admin account
> -SQL Server runs under another account
> -owner for databases is domain admin
> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
> -backupexec shows fileskipped messages without specifying the file
> -no usable info in eventvwr
> -there are jobs running on this database (although not when the backup is
> run)
> -no locks/active connections are shown in the enterprise manager
> Are there any issues with sql databases that are used by websites?
> Has anybody have experienced similar problems and have a sollution
> available that might work for me?
> thx.
> Perry
>
>|||Hi
Never use open file options against a SQL Server database as the DB and
Transaction log will never be restorable as they will not be in sync at a
point in time.
Backup the database to disk from within SQL Server (see BACKUP command in
BOL), or use the SQL Server maintenance wizard.
Backup the backup file files that SQL Server generated.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Perry" <reply@.to.ng> wrote in message
news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
> Hi group
> Working with backup exec 10, sql agent and advanced open file options
> included to backup our databases. We have 11 SQL databases varying in size
> from 200 to 5000mb. There is one new dbase which is the database for a
> website that is now not being backed up (size, approx 1.5 GB), this has
> never worked since it was created last week.
> (for now we are doing a full backup dump in non production hours to a
> location that is backed up)
> Additional info:
> -Backupexec runs under a domain admin account
> -SQL Server runs under another account
> -owner for databases is domain admin
> -2003 server for SQL (2000/sp3a) and the webserver (IIS6.0)
> -backupexec shows fileskipped messages without specifying the file
> -no usable info in eventvwr
> -there are jobs running on this database (although not when the backup is
> run)
> -no locks/active connections are shown in the enterprise manager
> Are there any issues with sql databases that are used by websites?
> Has anybody have experienced similar problems and have a sollution
> available that might work for me?
> thx.
> Perry
>
>|||Mike,
I have this same argument with my IT director. It's been one of those he
won't budge...I won't budge thing so...Veritas does have an agent for SQL
backups. We have the license but I've chosen not to use it (yet) not
because it doesn't work but because it is a bit more challenging and
involved. I do backup the databases using EM (jobs) then I use Veritas
BackupExec to backup the backup files to tape for off-site storage.
HTH
Jerry
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ObMOEeVxFHA.3756@.tk2msftngp13.phx.gbl...
> Hi
> Never use open file options against a SQL Server database as the DB and
> Transaction log will never be restorable as they will not be in sync at a
> point in time.
> Backup the database to disk from within SQL Server (see BACKUP command in
> BOL), or use the SQL Server maintenance wizard.
> Backup the backup file files that SQL Server generated.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Perry" <reply@.to.ng> wrote in message
> news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
>|||Jerry,
Below is what the log says, the servername is DC4, the databasename is
SYNERGY:
Job Completion Status
Job ended: Wednesday, September 28, 2005 at 8:36:41 PM
Completed status: Completed with exceptions
Errors
Click an error below to locate it in the job log
Backup- DC4 Database ?SYNERGY was not found, or could not be accessed.
Exceptions
Click an exception below to locate it in the job log
Backup- DC4 The item DC4\SYNERGY in use - skipped.Perry
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:u4j16tUxFHA.3740@.tk2msftngp13.phx.gbl...
> Perry,
> When you view the history for the backup job with BackupExec what error
> message is recorded, if any?
>
> Using? Are you using Enterprise Manager? If not, does that work? Any
> errors in the SQL errorlog for the backup failing?
> HTH
> Jerry
> "Perry" <reply@.to.ng> wrote in message
> news:ejIiKnUxFHA.1032@.TK2MSFTNGP12.phx.gbl...
>

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

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

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