backup failure

Hi
My DB backup and transaction backup of a database keep on failing with
the following error:
Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC
SQL Server Driver][SQL Server]Write on
'E:\SqlServer\testdb_db_200604221313.BAK' failed, status = 112. See the
SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.
Any idea what it really means ?
Thanks
DavidYou can get the description of Win32 error codes with NET HELPMSG from a
command prompt:

NET HELPMSG 112

Yields:

There is not enough space on the disk.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"David Greenberg" <davidgr@.iba.org.il> wrote in message
news:444B9239.2010804@.iba.org.il...
> Hi
> My DB backup and transaction backup of a database keep on failing with the
> following error:
> Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Write on
> 'E:\SqlServer\testdb_db_200604221313.BAK' failed, status = 112. See the
> SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
> terminating abnormally.
> Any idea what it really means ?
> Thanks
> David

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 Error: sql-dom sql state 4200

When trying to backup a sql2000 database I receive the following error:
"Microsoft SQL-DOM (odbc sqlstate: 42000)
The Volume on device xxx e:\backupfilename.bak belongs to a different media set.
Backup or restore operation terminating abnormally."
Thanks for any help,
JimIf you have no use for the existing backup file, you could
either delete the file from the file system before doing
the backup or add the FORMAT option to the BACKUP
statement.
Linchi
>--Original Message--
>When trying to backup a sql2000 database I receive the
following error:
>"Microsoft SQL-DOM (odbc sqlstate: 42000)
>The Volume on device xxx e:\backupfilename.bak belongs to
a different media set.
>Backup or restore operation terminating abnormally."
>Thanks for any help,
>Jim
>
>.
>

Backup Error

Hi'
I ma getting the following error some nights when I do
backups:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3023:
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup,
CHECKALLOC, bulk copy, SELECT INTO, and file manipulation
(such as CREATE FILE) operations on a database must be
serialized. Reissue the statement after the current
backup, CHECKALLOC, or file manipulation operation is
completed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or
restore operation terminating abnormally.
[43] Database master: Database Backup...
Nothing is running against the db at that time except the
backup.
Thanks in advace> Nothing is running against the db at that time except the
> backup.
If you are 100% certain it isn't, then you've found a bug and should search
if such is documented in KB and if not open a case with MS PSS. But start
with running a Profiler trace just to make sure you don't have such, could
be a job or something.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
<anonymous@.discussions.microsoft.com> wrote in message
news:e56501c40b72$badd5060$a101280a@.phx.gbl...
> Hi'
> I ma getting the following error some nights when I do
> backups:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3023:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Backup,
> CHECKALLOC, bulk copy, SELECT INTO, and file manipulation
> (such as CREATE FILE) operations on a database must be
> serialized. Reissue the statement after the current
> backup, CHECKALLOC, or file manipulation operation is
> completed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or
> restore operation terminating abnormally.
> [43] Database master: Database Backup...
> Nothing is running against the db at that time except the
> backup.
> Thanks in advace

backup db occurs error

Today I backup the SQLServer7.0,it prompt me error:
"Microsoft SQL-DMO(ODBC SQLState:42000)
Backup,CHECKALLOC,bulk copy,SELECT INTO,and file manipulation(such as CREATE FILE) operations on a database must be serialized.
Reissue the statement after the current backup,CHECKALLOC,or file manipulation operation is completed.
Backup or RESTORE OPERATION terminating abnormally."

Pls help me. Thanks with best regards.The error simply means that at the time the backup dump operation was attempted it could not be executed (because of other activity in progress).

Often, this is a result of attempting to run backups when maintenance is in progress.

If that is the issue try to run or schedule backup dumps at times when DB maintenance is complete (not in progress).sql

backup db

I'm trying to make a backup of a DB with a stored procedure. I call the sp
through an ODBC connection.When the backup is placed on a fixed disk
everything is OK. When a give a removable device as target the backup is
removed at the moment the odbc connection is closed. I need the backup on a
removable device.
How can I fix this?
an option is to make the backup on disk and copy it to the removable device,
but I don't know exactly when the backup is finished. can I add something in
the stored procedure to wait for the completion of the backup.
here is the sp:
CREATE PROCEDURE [dbo].[sp_Backup_DB]
@.path varchar (100)
AS
-- Back up the database.
BACKUP DATABASE PasV2 TO DISK = @.path
GOBert
I'm not sure undestand what are you after, however ,see in the BOL WAITFOR
command
"Bert Okkerse" <bizix@.skynet.be> wrote in message
news:uwpRa$LpGHA.148@.TK2MSFTNGP04.phx.gbl...
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
> a removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable
> device, but I don't know exactly when the backup is finished. can I add
> something in the stored procedure to wait for the completion of the
> backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>|||Hi,
If you want to make a copy of your database on removable media try
sp_create_removable
refer BOL for more info
Amol Lembhe
MCDBA
amol.lembhe@.patni.com
"Bert Okkerse" wrote:

> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
a
> removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable devic
e,
> but I don't know exactly when the backup is finished. can I add something
in
> the stored procedure to wait for the completion of the backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>
>

backup db

I'm trying to make a backup of a DB with a stored procedure. I call the sp
through an ODBC connection.When the backup is placed on a fixed disk
everything is OK. When a give a removable device as target the backup is
removed at the moment the odbc connection is closed. I need the backup on a
removable device.
How can I fix this?
an option is to make the backup on disk and copy it to the removable device,
but I don't know exactly when the backup is finished. can I add something in
the stored procedure to wait for the completion of the backup.
here is the sp:
CREATE PROCEDURE [dbo].[sp_Backup_DB]
@.path varchar (100)
AS
-- Back up the database.
BACKUP DATABASE PasV2 TO DISK = @.path
GOBert
I'm not sure undestand what are you after, however ,see in the BOL WAITFOR
command
"Bert Okkerse" <bizix@.skynet.be> wrote in message
news:uwpRa$LpGHA.148@.TK2MSFTNGP04.phx.gbl...
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on
> a removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable
> device, but I don't know exactly when the backup is finished. can I add
> something in the stored procedure to wait for the completion of the
> backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>|||Hi,
If you want to make a copy of your database on removable media try
sp_create_removable
refer BOL for more info
Amol Lembhe
MCDBA
amol.lembhe@.patni.com
"Bert Okkerse" wrote:
> I'm trying to make a backup of a DB with a stored procedure. I call the sp
> through an ODBC connection.When the backup is placed on a fixed disk
> everything is OK. When a give a removable device as target the backup is
> removed at the moment the odbc connection is closed. I need the backup on a
> removable device.
> How can I fix this?
> an option is to make the backup on disk and copy it to the removable device,
> but I don't know exactly when the backup is finished. can I add something in
> the stored procedure to wait for the completion of the backup.
> here is the sp:
> CREATE PROCEDURE [dbo].[sp_Backup_DB]
> @.path varchar (100)
> AS
> -- Back up the database.
> BACKUP DATABASE PasV2 TO DISK = @.path
> GO
>
>