Backup Failure - Operating system error 64

I am receiving the below error message while doing a Database backup as a
schedule dts package job.
Operating system error 64(The specified network name is no longer available.).
or
Operating system error 64(error not found).
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup device '
\\SERVER_NAME\SQLBackup\Production\DatabaseName.ba k'. Operating system error
64(error not found).
18210 :
BackupMedium::ReportIoError: write failure on backup device
'\\\SERVER_NAME\SQLBackup\Production\DatabaseName. bak'. Operating system
error 64(error not found).
Please note, I am backing up to a networked drive/location using the below
command as an example, which is not a mapped drive,
BACKUP DATABASE [DatabaseName] TO DISK =
\\SERVER_NAME\SQLBackup\Production\DatabaseName.ba k' WITH INIT
The same scheduled dts package backup job sometimes run successfully at
the scheduled time and most times failed. The job is ran under the SQL Server
Agent account which has full access permission to the backup network drive.
The backup dts package always run successfully when ran manually using my
login account.
Thank you and kind regards
Michael
Michael,
The OS error 64 usually indicates the network problems.
Intermittent loss of connectivity to the share. To ensure that the
backups for the database are taken properly, I recommend you backup to
the local drive and then create a NT job to move the job to the share
upon completion of the SQL Backup. If the Nt copy job fails, then we
can be sure that the problem is because of network connectivity.
Hope that helps.
Venu
"Michael" <Michael@.discussions.microsoft.com> wrote in message news:<9973687E-E0C3-41C6-BAF3-D0C240895A01@.microsoft.com>...
> I am receiving the below error message while doing a Database backup as a
> schedule dts package job.
> Operating system error 64(The specified network name is no longer available.).
> or
> Operating system error 64(error not found).
> 18210 :
> BackupDiskFile::RequestDurableMedia: failure on backup device '
> \\SERVER_NAME\SQLBackup\Production\DatabaseName.ba k'. Operating system error
> 64(error not found).
> 18210 :
> BackupMedium::ReportIoError: write failure on backup device
> '\\\SERVER_NAME\SQLBackup\Production\DatabaseName. bak'. Operating system
> error 64(error not found).
>
> Please note, I am backing up to a networked drive/location using the below
> command as an example, which is not a mapped drive,
> BACKUP DATABASE [DatabaseName] TO DISK =
> \\SERVER_NAME\SQLBackup\Production\DatabaseName.ba k' WITH INIT
> The same scheduled dts package backup job sometimes run successfully at
> the scheduled time and most times failed. The job is ran under the SQL Server
> Agent account which has full access permission to the backup network drive.
> The backup dts package always run successfully when ran manually using my
> login account.
> Thank you and kind regards
> Michael

Backup Failure - Operating system error 64

I am receiving the below error message while doing a Database backup as a
schedule dts package job.
Operating system error 64(The specified network name is no longer available.
).
or
Operating system error 64(error not found).
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup device '
\\SERVER_NAME\SQLBackup\Production\Datab
aseName.bak'. Operating system error
64(error not found).
18210 :
BackupMedium::ReportIoError: write failure on backup device
'\\\SERVER_NAME\SQLBackup\Production\Dat
abaseName.bak'. Operating system
error 64(error not found).
Please note, I am backing up to a networked drive/location using the below
command as an example, which is not a mapped drive,
BACKUP DATABASE [DatabaseName] TO DISK =
\\SERVER_NAME\SQLBackup\Production\Datab
aseName.bak' WITH INIT
The same scheduled dts package backup job sometimes run successfully at
the scheduled time and most times failed. The job is ran under the SQL Serve
r
Agent account which has full access permission to the backup network drive.
The backup dts package always run successfully when ran manually using my
login account.
Thank you and kind regards
MichaelMichael,
The OS error 64 usually indicates the network problems.
Intermittent loss of connectivity to the share. To ensure that the
backups for the database are taken properly, I recommend you backup to
the local drive and then create a NT job to move the job to the share
upon completion of the SQL Backup. If the Nt copy job fails, then we
can be sure that the problem is because of network connectivity.
Hope that helps.
Venu
"Michael" <Michael@.discussions.microsoft.com> wrote in message news:<9973687E-E0C3-41C6-BAF3
-D0C240895A01@.microsoft.com>...
> I am receiving the below error message while doing a Database backup as a
> schedule dts package job.
> Operating system error 64(The specified network name is no longer availabl
e.).
> or
> Operating system error 64(error not found).
> 18210 :
> BackupDiskFile::RequestDurableMedia: failure on backup device '
> \\SERVER_NAME\SQLBackup\Production\Datab
aseName.bak'. Operating system err
or
> 64(error not found).
> 18210 :
> BackupMedium::ReportIoError: write failure on backup device
> '\\\SERVER_NAME\SQLBackup\Production\Dat
abaseName.bak'. Operating system
> error 64(error not found).
>
> Please note, I am backing up to a networked drive/location using the below
> command as an example, which is not a mapped drive,
> BACKUP DATABASE [DatabaseName] TO DISK =
> \\SERVER_NAME\SQLBackup\Production\Datab
aseName.bak' WITH INIT
> The same scheduled dts package backup job sometimes run successfully at
> the scheduled time and most times failed. The job is ran under the SQL Ser
ver
> Agent account which has full access permission to the backup network drive
.
> The backup dts package always run successfully when ran manually using my
> login account.
> Thank you and kind regards
> Michael

Backup Failure - Operating system error 64

I am receiving the below error message while doing a Database backup as a
schedule dts package job.
Operating system error 64(The specified network name is no longer available.).
or
Operating system error 64(error not found).
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup device '
\\SERVER_NAME\SQLBackup\Production\DatabaseName.bak'. Operating system error
64(error not found).
18210 :
BackupMedium::ReportIoError: write failure on backup device
'\\\SERVER_NAME\SQLBackup\Production\DatabaseName.bak'. Operating system
error 64(error not found).
Please note, I am backing up to a networked drive/location using the below
command as an example, which is not a mapped drive,
BACKUP DATABASE [DatabaseName] TO DISK = \\SERVER_NAME\SQLBackup\Production\DatabaseName.bak' WITH INIT
The same scheduled dts package backup job sometimes run successfully at
the scheduled time and most times failed. The job is ran under the SQL Server
Agent account which has full access permission to the backup network drive.
The backup dts package always run successfully when ran manually using my
login account.
Thank you and kind regards
MichaelMichael,
The OS error 64 usually indicates the network problems.
Intermittent loss of connectivity to the share. To ensure that the
backups for the database are taken properly, I recommend you backup to
the local drive and then create a NT job to move the job to the share
upon completion of the SQL Backup. If the Nt copy job fails, then we
can be sure that the problem is because of network connectivity.
Hope that helps.
Venu
"Michael" <Michael@.discussions.microsoft.com> wrote in message news:<9973687E-E0C3-41C6-BAF3-D0C240895A01@.microsoft.com>...
> I am receiving the below error message while doing a Database backup as a
> schedule dts package job.
> Operating system error 64(The specified network name is no longer available.).
> or
> Operating system error 64(error not found).
> 18210 :
> BackupDiskFile::RequestDurableMedia: failure on backup device '
> \\SERVER_NAME\SQLBackup\Production\DatabaseName.bak'. Operating system error
> 64(error not found).
> 18210 :
> BackupMedium::ReportIoError: write failure on backup device
> '\\\SERVER_NAME\SQLBackup\Production\DatabaseName.bak'. Operating system
> error 64(error not found).
>
> Please note, I am backing up to a networked drive/location using the below
> command as an example, which is not a mapped drive,
> BACKUP DATABASE [DatabaseName] TO DISK => \\SERVER_NAME\SQLBackup\Production\DatabaseName.bak' WITH INIT
> The same scheduled dts package backup job sometimes run successfully at
> the scheduled time and most times failed. The job is ran under the SQL Server
> Agent account which has full access permission to the backup network drive.
> The backup dts package always run successfully when ran manually using my
> login account.
> Thank you and kind regards
> Michaelsql

Backup fails with Error Message SQL-DMO (ODBC SQLState:42000) - Need Help !

Hi,

This is my first posting and actually I have big problem which I need to resolve immediately:

I have a 38 GB Database on my SQL Server which I want to full-backup. Until now backup was created on the same volume where the database resides. But now the volume is out of disk space. So what we did is that we connected an external USB disk drive with 500 GB to the SQL Server and try to backup there.

But our first and all consecutive backup attemps failed with error SQL-DMO (ODBC SQLState: 42000). It's working fine the first few minutes as we can see that the backup file is continously growing. But then it abruptly aborts with above error message.

Can anyone figure out why ? Any help is appreciated.

Thx
Overlord1970Hi

I can't help with the message or backing up onto the usb (never done the latter, don't think I know the former) but can you move stuff off the volume onto the USB drive and backup to the volume as usual?

Obviously this is not something you are too concerned about now but in future you will need to do some capacity planning and trending so you don't get caught in this situation again.|||ok - 42000 turns out to be generic. What's the full error message? How are you backing up (sqlmaint, via DMO, T-SQL, management studio etc)?|||OK. Here some more info which might be usefull:
Database: SQL Server 2000 with SP3
Backup device: Western Digital External USB Drive 500 GB|||OK. Backup failed once again. Full error message reads:

Write on 'F:\New Folder\cpmapp_sun_baymak_full_151107' failed, status = 112, See the SQL Server error log for more details. BACKUP DATABASE is terminating abnormaly.

I'm using SQL Server Enterprise Manager's SQL Server Backup Utility (with default settings).

NET HELPMSG 112 indicates that 'There is not enough space on the disk'

But the USB drive has more than 390 GB free.
The DB I want to backup is 38 GB big.|||I think I found the cause of the problem:

The Western Digital External USB Storage comes preformatted with FAT32.

On Western Digital's FAQ Page it says:

"A file cannot be transferred to a FAT32 partition if the file is larger than 4GB."

On the other hand, the DB I want to backup is 38 GB big !

I will reformat the external storage with NTFS and try again.

I will post an update after trying :)sql

Backup failed: Operating system error 112(error not found).

Hi,
I keep getting this error message for a trans.log backup.
Operating system error
112(error not found).
The disk has about 6GB space free, and the backup should only take up
about 550 MB, so I would think it is not space related but...
The disk is NTFS.
Any ideas?smeagol (carlamichelle1@.hotmail.com) writes:
> I keep getting this error message for a trans.log backup.
> Operating system error
> 112(error not found).
> The disk has about 6GB space free, and the backup should only take up
> about 550 MB, so I would think it is not space related but...

... but NET HELPMSG 112 says

There is not enough space on the disk.

> The disk is NTFS.
> Any ideas?

Not many. I would perform all sorts of sanity checks that you are looking
on the right disk, that the transaction log is small as you believe it
to be etc.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Did you ever get this sorted ?
I'm having the same problem and have heaps of free disk space ? :confused:sql

BACKUP failed to complete the command sp_execute;1

Does anyone know why message appears and how to correct problem?
During a database backup the message of "BACKUP failed to complete the
command sp_execute;1" appears in the SQL log. The backup seems to complete
sucessful. The backup command is as follow:
BACKUP DATABASE @.dbname TO DISK = \\ServerA\Backup\BackupXDB.dat WITH
DIFFERENTIAL, INIT
as you may not the backup is being directed to a network drive
SQL Env: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Thanks in advance
Did you try to apply the differential backup to see if it's valid? Also, if
you run the same command from Query Analyzer, do you get the same error?
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"SQLDBA" <SQLDBA@.discussions.microsoft.com> wrote in message
news:4649BE64-B000-4692-A59D-B7DA0E1F1C5D@.microsoft.com...
> Does anyone know why message appears and how to correct problem?
> During a database backup the message of "BACKUP failed to complete the
> command sp_execute;1" appears in the SQL log. The backup seems to
complete
> sucessful. The backup command is as follow:
> BACKUP DATABASE @.dbname TO DISK = \\ServerA\Backup\BackupXDB.dat WITH
> DIFFERENTIAL, INIT
> as you may not the backup is being directed to a network drive
> SQL Env: Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> May 31 2003 16:08:15
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
> Thanks in advance
>

Backup Errors in sqlserver

Hello all,

How can I resolve this error message I keep getting when I try to backup my database?

Thanks in Advance.

"Can't open dump device 'D:\MSSQL\BACKUP\dmpApp_tracker.DAT', device error or device off line. Please consult the SQL Server error log for more details. (Message 3201)"Are you appending to the device? I've seen this happen when an active backup operation gets interrupted. After that the device needs to be re-created. If you were appending backups to it see if you can recover the ones that you intend to keep.|||No, I am not appending to it. This is sqlserver 6.5 and it does not give you that option. It does have a expire after date and I set that to 7. Thanks for the help.|||6.5?

Deal me out...

What did the error log say?|||Yes it does! WITH NOINIT is available in 6.5 SP5a, look closely!

Backup Error Message

I am receiving a BackupDiskFile::RequestDurableMedia error when backing up to a backup device pointing to a file on the hard drive. This only happens for one of the devices and there are several others, configured similarly, that work just fine. I'm won
dering if anyone has seen this before and can shed some light on what could be causing this. The error message continues with: Operating system error 64 (The specified network name is no longer available).
Sometimes you will see this with the larger backups If you are trying to
backing up locally using a network share. Attempt the backup by using the
file path instead of the share name.
HTH
SQL Server Support
Agnes Panosian

Backup Error Message

I am receiving a BackupDiskFile::RequestDurableMedia error when backing up t
o a backup device pointing to a file on the hard drive. This only happens f
or one of the devices and there are several others, configured similarly, th
at work just fine. I'm won
dering if anyone has seen this before and can shed some light on what could
be causing this. The error message continues with: Operating system error 6
4 (The specified network name is no longer available).Sometimes you will see this with the larger backups If you are trying to
backing up locally using a network share. Attempt the backup by using the
file path instead of the share name.
HTH
SQL Server Support
Agnes Panosiansql

Backup Error Message

I have SQL Server 2000. I am trying to manually backup a
database but I'm getting an error message.
Here is what I'm trying to do:
1. In the Backup dialogue box I click Add to select the
backup location.
2. The default backup location is already selected. I want
to save the backup to a different location (local hard
disk) so I select the location and enter a file name.
3. When I try to run the backup I get an error message:
Microsoft SQL DMO (ODBC SQLState: 42000) "The volume in
device <filepath> is not part of a multi family media set.
Backup with format can be used to form a new media set.
Backup database is terminating abnormally."
4. The backup fails to run. However, if I select the
default location (which is not what I want) the backup
will run.
How do I backup a database to a location other than the
default?
Thanks in advance.This is not a location issue. You are using a backup file
that was part of striped backup media set. If that backup
file is no longer useful, you can delete that file and the
backup would work.
For backup/restore, personally I would never use the EM
GUI, and I'll use BACKUP/RESTORE statements instead. You
get much better control of what you want to do without any
GUI-related peculiarities getting in the way.
Linchi
>--Original Message--
>I have SQL Server 2000. I am trying to manually backup a
>database but I'm getting an error message.
>Here is what I'm trying to do:
>1. In the Backup dialogue box I click Add to select the
>backup location.
>2. The default backup location is already selected. I
want
>to save the backup to a different location (local hard
>disk) so I select the location and enter a file name.
>3. When I try to run the backup I get an error message:
>Microsoft SQL DMO (ODBC SQLState: 42000) "The volume in
>device <filepath> is not part of a multi family media
set.
>Backup with format can be used to form a new media set.
>Backup database is terminating abnormally."
>4. The backup fails to run. However, if I select the
>default location (which is not what I want) the backup
>will run.
>How do I backup a database to a location other than the
>default?
>Thanks in advance.
>
>.
>|||There is a backup of the database in the default location
but not in the new location. The new backup location is an
empty folder.
>--Original Message--
>This is not a location issue. You are using a backup file
>that was part of striped backup media set. If that backup
>file is no longer useful, you can delete that file and
the
>backup would work.
>For backup/restore, personally I would never use the EM
>GUI, and I'll use BACKUP/RESTORE statements instead. You
>get much better control of what you want to do without
any
>GUI-related peculiarities getting in the way.
>Linchi
>>--Original Message--
>>I have SQL Server 2000. I am trying to manually backup a
>>database but I'm getting an error message.
>>Here is what I'm trying to do:
>>1. In the Backup dialogue box I click Add to select the
>>backup location.
>>2. The default backup location is already selected. I
>want
>>to save the backup to a different location (local hard
>>disk) so I select the location and enter a file name.
>>3. When I try to run the backup I get an error message:
>>Microsoft SQL DMO (ODBC SQLState: 42000) "The volume in
>>device <filepath> is not part of a multi family media
>set.
>>Backup with format can be used to form a new media set.
>>Backup database is terminating abnormally."
>>4. The backup fails to run. However, if I select the
>>default location (which is not what I want) the backup
>>will run.
>>How do I backup a database to a location other than the
>>default?
>>Thanks in advance.
>>
>>.
>.
>|||Really? Then, I'd try the BACKUP DATABASE statement and backup the database
to the exact backup file in the new location as you did with the EM. If the
folder is empty, I doubt you'd get the that error.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:037901c39e6e$b0d89140$a501280a@.phx.gbl...
> There is a backup of the database in the default location
> but not in the new location. The new backup location is an
> empty folder.
> >--Original Message--
> >This is not a location issue. You are using a backup file
> >that was part of striped backup media set. If that backup
> >file is no longer useful, you can delete that file and
> the
> >backup would work.
> >
> >For backup/restore, personally I would never use the EM
> >GUI, and I'll use BACKUP/RESTORE statements instead. You
> >get much better control of what you want to do without
> any
> >GUI-related peculiarities getting in the way.
> >
> >Linchi
> >
> >>--Original Message--
> >>I have SQL Server 2000. I am trying to manually backup a
> >>database but I'm getting an error message.
> >>
> >>Here is what I'm trying to do:
> >>1. In the Backup dialogue box I click Add to select the
> >>backup location.
> >>2. The default backup location is already selected. I
> >want
> >>to save the backup to a different location (local hard
> >>disk) so I select the location and enter a file name.
> >>3. When I try to run the backup I get an error message:
> >>Microsoft SQL DMO (ODBC SQLState: 42000) "The volume in
> >>device <filepath> is not part of a multi family media
> >set.
> >>Backup with format can be used to form a new media set.
> >>Backup database is terminating abnormally."
> >>4. The backup fails to run. However, if I select the
> >>default location (which is not what I want) the backup
> >>will run.
> >>
> >>How do I backup a database to a location other than the
> >>default?
> >>
> >>Thanks in advance.
> >>
> >>
> >>.
> >>
> >.
> >

backup error 17055 description 3041

I am getting this error when trying to bakup a database to a file. I am using the default filename and location. The error message is:
2004-02-29 01:00:00.79 backup BACKUP failed to complete the command BACKUP DATABASE [afdb000001_beSQL] TO DISK = N'd:\SQL Data\MSSQL\BACKUP\fordev.bak' WITH NOINIT , NOUNLOAD , NAME = N'afdb000001_beSQL backup', NOSKIP , STATS = 10, NOFORMAT
Any help would be appreciated.
Chris,
A couple of questions.
1) Do you have enough space on the D drive?
2) What is the D drive? Local SCSI, network drive, CD-ROM, SAN?
This error may occur sometimes when backing up over the network when there are network infrastructure issues.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
|||Did you ever get this resolved?
I am wondering what you did?

backup error 17055 description 3041

I am getting this error when trying to bakup a database to a file. I am usin
g the default filename and location. The error message is:
2004-02-29 01:00:00.79 backup BACKUP failed to complete the command BACKU
P DATABASE [afdb000001_beSQL] TO DISK = N'd:\SQL Data\MSSQL\BACKUP\ford
ev.bak' WITH NOINIT , NOUNLOAD , NAME = N'afdb000001_beSQL backup', NOSK
IP , STATS = 10, NOFORMAT
Any help would be appreciated.Chris,
A couple of questions.
1) Do you have enough space on the D drive?
2) What is the D drive? Local SCSI, network drive, CD-ROM, SAN?
This error may occur sometimes when backing up over the network when there a
re network infrastructure issues.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Did you ever get this resolved?
I am wondering what you did?

Backup error

I have this error:
SQL Server Scheduled Task: 43, 'BackupIBMDat - tempdb' --
Status: Failed
-- Task Invoked on: 1/21/04 1:30:00 AM -- Message: Can't
open dump device '\\.\TAPE0', device error or device off
line. Please consult the SQL Server error log for more
details. (Message 3201)
please help meso does SQL Server error log have anything regarding this?
see if you can run a backup to that \\TAPE0 device. Is the spelling right
for the device name?
"Whill" <anonymous@.discussions.microsoft.com> wrote in message
news:1c8d01c3e050$a5d94130$a001280a@.phx.gbl...

quote:

---

> I have this error:
> SQL Server Scheduled Task: 43, 'BackupIBMDat - tempdb' --
> Status: Failed
> -- Task Invoked on: 1/21/04 1:30:00 AM -- Message: Can't
> open dump device '\\.\TAPE0', device error or device off
> line. Please consult the SQL Server error log for more
> details. (Message 3201)
> please help me

---

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

Backup Database on the network

I tried to backup the database on the network, which is in the same
workgroup; i received an ERROR message, Which says
"BackupDiskFile::CreateMedia: Backup device
'\\Servername\SharedName\FileName.BAK' failed to create. Operating system
error = 5(Access is denied.)."
Is there anyone have an idia to solve my problem. I appreciate your help.
Thanks.
The account that SQL Server runs under must have permissions to read and
write to that share.
Andrew J. Kelly SQL MVP
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>I tried to backup the database on the network, which is in the same
> workgroup; i received an ERROR message, Which says
> "BackupDiskFile::CreateMedia: Backup device
> '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> error = 5(Access is denied.)."
> Is there anyone have an idia to solve my problem. I appreciate your help.
> Thanks.
|||Also, check to make sure your SQL Service account is a domain account (but i
guess that would be implied).
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>I tried to backup the database on the network, which is in the same
> workgroup; i received an ERROR message, Which says
> "BackupDiskFile::CreateMedia: Backup device
> '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> error = 5(Access is denied.)."
> Is there anyone have an idia to solve my problem. I appreciate your help.
> Thanks.
|||We don't have any Domain, we are working in Workgroup model. The SQL Server
and the Server which I want to have backup on it, are in different Workgroup.
Is there any methode to solve this?
"Shaun Beane" wrote:

> Also, check to make sure your SQL Service account is a domain account (but i
> guess that would be implied).
> "betrek" <betrek@.discussions.microsoft.com> wrote in message
> news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>
>
|||Hi
Make sure SQL Server runs under an account where there is the same account
on both machines, with exactly the same passwords.
BTW, You can not use the Maintenance Plan Wizard as you need to use UNC
names. So you have to write T-SQL with the BACKUP command in it.
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/
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:CB7AE853-4204-49EC-8684-889CF1FBB9B0@.microsoft.com...
> We don't have any Domain, we are working in Workgroup model. The SQL
Server
> and the Server which I want to have backup on it, are in different
Workgroup.[vbcol=seagreen]
> Is there any methode to solve this?
>
> "Shaun Beane" wrote:
(but i[vbcol=seagreen]
system[vbcol=seagreen]
help.[vbcol=seagreen]
|||There is a way to use Maintenance plans and UNC names together.
Here is a comprehensive set of instructions on exactly how to do it.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default...b;en-us;555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ecSnti9MFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Hi
> Make sure SQL Server runs under an account where there is the same account
> on both machines, with exactly the same passwords.
> BTW, You can not use the Maintenance Plan Wizard as you need to use UNC
> names. So you have to write T-SQL with the BACKUP command in it.
> 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/
> "betrek" <betrek@.discussions.microsoft.com> wrote in message
> news:CB7AE853-4204-49EC-8684-889CF1FBB9B0@.microsoft.com...
> Server
> Workgroup.
> (but i
> system
> help.
>

Backup Database on the network

I tried to backup the database on the network, which is in the same
workgroup; i received an ERROR message, Which says
"BackupDiskFile::CreateMedia: Backup device
'\\Servername\SharedName\FileName.BAK' failed to create. Operating system
error = 5(Access is denied.)."
Is there anyone have an idia to solve my problem. I appreciate your help.
Thanks.The account that SQL Server runs under must have permissions to read and
write to that share.
--
Andrew J. Kelly SQL MVP
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>I tried to backup the database on the network, which is in the same
> workgroup; i received an ERROR message, Which says
> "BackupDiskFile::CreateMedia: Backup device
> '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> error = 5(Access is denied.)."
> Is there anyone have an idia to solve my problem. I appreciate your help.
> Thanks.|||Also, check to make sure your SQL Service account is a domain account (but i
guess that would be implied).
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>I tried to backup the database on the network, which is in the same
> workgroup; i received an ERROR message, Which says
> "BackupDiskFile::CreateMedia: Backup device
> '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> error = 5(Access is denied.)."
> Is there anyone have an idia to solve my problem. I appreciate your help.
> Thanks.|||We don't have any Domain, we are working in Workgroup model. The SQL Server
and the Server which I want to have backup on it, are in different Workgroup.
Is there any methode to solve this?
"Shaun Beane" wrote:
> Also, check to make sure your SQL Service account is a domain account (but i
> guess that would be implied).
> "betrek" <betrek@.discussions.microsoft.com> wrote in message
> news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
> >I tried to backup the database on the network, which is in the same
> > workgroup; i received an ERROR message, Which says
> > "BackupDiskFile::CreateMedia: Backup device
> > '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> > error = 5(Access is denied.)."
> > Is there anyone have an idia to solve my problem. I appreciate your help.
> >
> > Thanks.
>
>|||Hi
Make sure SQL Server runs under an account where there is the same account
on both machines, with exactly the same passwords.
BTW, You can not use the Maintenance Plan Wizard as you need to use UNC
names. So you have to write T-SQL with the BACKUP command in it.
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/
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:CB7AE853-4204-49EC-8684-889CF1FBB9B0@.microsoft.com...
> We don't have any Domain, we are working in Workgroup model. The SQL
Server
> and the Server which I want to have backup on it, are in different
Workgroup.
> Is there any methode to solve this?
>
> "Shaun Beane" wrote:
> > Also, check to make sure your SQL Service account is a domain account
(but i
> > guess that would be implied).
> >
> > "betrek" <betrek@.discussions.microsoft.com> wrote in message
> > news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
> > >I tried to backup the database on the network, which is in the same
> > > workgroup; i received an ERROR message, Which says
> > > "BackupDiskFile::CreateMedia: Backup device
> > > '\\Servername\SharedName\FileName.BAK' failed to create. Operating
system
> > > error = 5(Access is denied.)."
> > > Is there anyone have an idia to solve my problem. I appreciate your
help.
> > >
> > > Thanks.
> >
> >
> >|||There is a way to use Maintenance plans and UNC names together.
Here is a comprehensive set of instructions on exactly how to do it.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ecSnti9MFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Hi
> Make sure SQL Server runs under an account where there is the same account
> on both machines, with exactly the same passwords.
> BTW, You can not use the Maintenance Plan Wizard as you need to use UNC
> names. So you have to write T-SQL with the BACKUP command in it.
> 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/
> "betrek" <betrek@.discussions.microsoft.com> wrote in message
> news:CB7AE853-4204-49EC-8684-889CF1FBB9B0@.microsoft.com...
>> We don't have any Domain, we are working in Workgroup model. The SQL
> Server
>> and the Server which I want to have backup on it, are in different
> Workgroup.
>> Is there any methode to solve this?
>>
>> "Shaun Beane" wrote:
>> > Also, check to make sure your SQL Service account is a domain account
> (but i
>> > guess that would be implied).
>> >
>> > "betrek" <betrek@.discussions.microsoft.com> wrote in message
>> > news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>> > >I tried to backup the database on the network, which is in the same
>> > > workgroup; i received an ERROR message, Which says
>> > > "BackupDiskFile::CreateMedia: Backup device
>> > > '\\Servername\SharedName\FileName.BAK' failed to create. Operating
> system
>> > > error = 5(Access is denied.)."
>> > > Is there anyone have an idia to solve my problem. I appreciate your
> help.
>> > >
>> > > Thanks.
>> >
>> >
>> >
>

Backup Database on the network

I tried to backup the database on the network, which is in the same
workgroup; i received an ERROR message, Which says
"BackupDiskFile::CreateMedia: Backup device
'\\Servername\SharedName\FileName.BAK' failed to create. Operating system
error = 5(Access is denied.)."
Is there anyone have an idia to solve my problem. I appreciate your help.
Thanks.The account that SQL Server runs under must have permissions to read and
write to that share.
Andrew J. Kelly SQL MVP
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>I tried to backup the database on the network, which is in the same
> workgroup; i received an ERROR message, Which says
> "BackupDiskFile::CreateMedia: Backup device
> '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> error = 5(Access is denied.)."
> Is there anyone have an idia to solve my problem. I appreciate your help.
> Thanks.|||Also, check to make sure your SQL Service account is a domain account (but i
guess that would be implied).
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>I tried to backup the database on the network, which is in the same
> workgroup; i received an ERROR message, Which says
> "BackupDiskFile::CreateMedia: Backup device
> '\\Servername\SharedName\FileName.BAK' failed to create. Operating system
> error = 5(Access is denied.)."
> Is there anyone have an idia to solve my problem. I appreciate your help.
> Thanks.|||We don't have any Domain, we are working in Workgroup model. The SQL Server
and the Server which I want to have backup on it, are in different Workgroup
.
Is there any methode to solve this?
"Shaun Beane" wrote:

> Also, check to make sure your SQL Service account is a domain account (but
i
> guess that would be implied).
> "betrek" <betrek@.discussions.microsoft.com> wrote in message
> news:6387F0CA-A717-467A-9F4B-F0EF7AED2D5A@.microsoft.com...
>
>|||Hi
Make sure SQL Server runs under an account where there is the same account
on both machines, with exactly the same passwords.
BTW, You can not use the Maintenance Plan Wizard as you need to use UNC
names. So you have to write T-SQL with the BACKUP command in it.
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/
"betrek" <betrek@.discussions.microsoft.com> wrote in message
news:CB7AE853-4204-49EC-8684-889CF1FBB9B0@.microsoft.com...
> We don't have any Domain, we are working in Workgroup model. The SQL
Server
> and the Server which I want to have backup on it, are in different
Workgroup.[vbcol=seagreen]
> Is there any methode to solve this?
>
> "Shaun Beane" wrote:
>
(but i[vbcol=seagreen]
system[vbcol=seagreen]
help.[vbcol=seagreen]|||There is a way to use Maintenance plans and UNC names together.
Here is a comprehensive set of instructions on exactly how to do it.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/defaul...kb;en-us;555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ecSnti9MFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Hi
> Make sure SQL Server runs under an account where there is the same account
> on both machines, with exactly the same passwords.
> BTW, You can not use the Maintenance Plan Wizard as you need to use UNC
> names. So you have to write T-SQL with the BACKUP command in it.
> 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/
> "betrek" <betrek@.discussions.microsoft.com> wrote in message
> news:CB7AE853-4204-49EC-8684-889CF1FBB9B0@.microsoft.com...
> Server
> Workgroup.
> (but i
> system
> help.
>

Backup Database Fails with "backup database is terminating abnormally" message

I have many databases that I can backup just fine on my
SQL Server. However, there is one database that I cannot
backup without the following message:

"backup database is terminating abnormally".

The strange thing is that the database really does get
backed up despite the messages; I've even done restores
from the backup.

When I checked the event log, there are two errors.

ONE:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 8/25/2003
Time: 08:23:59
User: MARIN\aaronosheroff
Computer: IS-DBS2
Description:
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup
device '\\Ivcserv1
\SqlServerBackups\HP_STUREC_MCC_CES.BAK'. Operating system
error 64(The specified network name is no longer
available.).

Data:
0000: 22 47 00 00 10 00 00 00 "G.....
0008: 08 00 00 00 49 00 53 00 ...I.S.
0010: 2d 00 44 00 42 00 53 00 -.D.B.S.
0018: 32 00 00 00 00 00 00 00 2......

and TWO:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 8/25/2003
Time: 08:23:59
User: MARIN\aaronosheroff
Computer: IS-DBS2
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE
[HP_STUREC_MCC_CES] TO DISK = N'\\Ivcserv1
\SqlServerBackups\HP_STUREC_MCC_CES.BAK' WITH INIT ,
NOUNLOAD , NAME = N'HP_STUREC_MCC_CES backup', NOSKIP ,
STATS = 10, NOFORMAT

Data:
0000: e1 0b 00 00 10 00 00 00 ......
0008: 08 00 00 00 49 00 53 00 ...I.S.
0010: 2d 00 44 00 42 00 53 00 -.D.B.S.
0018: 32 00 00 00 00 00 00 00 2......

Can someone help me out here? Thanks...Originally posted by DrummerCA33
I have many databases that I can backup just fine on my
SQL Server. However, there is one database that I cannot
backup without the following message:

"backup database is terminating abnormally".

The strange thing is that the database really does get
backed up despite the messages; I've even done restores
from the backup.

When I checked the event log, there are two errors.

ONE:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 8/25/2003
Time: 08:23:59
User: MARIN\aaronosheroff
Computer: IS-DBS2
Description:
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup
device '\\Ivcserv1
\SqlServerBackups\HP_STUREC_MCC_CES.BAK'. Operating system
error 64(The specified network name is no longer
available.).

Data:
0000: 22 47 00 00 10 00 00 00 "G.....
0008: 08 00 00 00 49 00 53 00 ...I.S.
0010: 2d 00 44 00 42 00 53 00 -.D.B.S.
0018: 32 00 00 00 00 00 00 00 2......

and TWO:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 8/25/2003
Time: 08:23:59
User: MARIN\aaronosheroff
Computer: IS-DBS2
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE
[HP_STUREC_MCC_CES] TO DISK = N'\\Ivcserv1
\SqlServerBackups\HP_STUREC_MCC_CES.BAK' WITH INIT ,
NOUNLOAD , NAME = N'HP_STUREC_MCC_CES backup', NOSKIP ,
STATS = 10, NOFORMAT

Data:
0000: e1 0b 00 00 10 00 00 00 ......
0008: 08 00 00 00 49 00 53 00 ...I.S.
0010: 2d 00 44 00 42 00 53 00 -.D.B.S.
0018: 32 00 00 00 00 00 00 00 2......

Can someone help me out here? Thanks...

Come on...anyone?|||u sure that it is a current backup? Not a previous backup...

mike|||Do you run your backup with the agent? Did you try to just paste the command into QA and see how it does it? Also, check with your sysadmin or whoever is responsible for windows logins, and see if he/she can confirm there is no implied policy that somehow affects this particular share.|||Originally posted by wukie
u sure that it is a current backup? Not a previous backup...

mike

Could you please clarify what you're asking? Thanks for the post!|||Originally posted by rdjabarov
Do you run your backup with the agent? Did you try to just paste the command into QA and see how it does it? Also, check with your sysadmin or whoever is responsible for windows logins, and see if he/she can confirm there is no implied policy that somehow affects this particular share.

Thanks for the post. I've run it with the agent; cut & pasted it into QA, it doesn't matter. The network share is just fine; it works with the other databases. The only difference between this and the other databases is that this one is about 2.2 gigs, the others are smaller.|||if you delete the file on disk and then run the backup, does the bu still produce a usable backup file?

Mike|||Originally posted by wukie
if you delete the file on disk and then run the backup, does the bu still produce a usable backup file?

Mike

Yes. A usuable copy is made. It's just that the backup always "fails" with the error messages I've described.|||OK...some kind people have found the solution. By backing up to the LOCAL DRIVE (D:) it complete without the error message. Then, I guess I can just copy the backup file the the share as part of a script or something.

Thanks everyone who responded!!