Monday, March 19, 2012

Error in scheduled back up

I've been pulling my hair over this message in my daily backup log...
I found an article for this error message in knowledge base (274743), and it
has something to do with SMS database. But we do not use SMS. So, I don't
know how to solve this problem...
This error moves around every day... sometimes Master doesn't get backed up
, sometimes model...
I'm not 100% sure, but maybe it started after I started to run optimization
job...
I'd appreciate any help on this... Thank you!
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3023: [Microsoft]&#
91;ODBC SQL Server Driver][SQL Server]Backup, CHECKALLOC, bulk copy, SEL
ECT INTO, and file manipulation (such as CREATE FILE) operations on a databa
se must be serialized. Reissue the statemen
t after the current backup, CHECKALLOC, or file manipulation operation is co
mpleted.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore
operation terminating abnormally.The error is from some other operation such as those listed,
was running when you executed the backup.
The optimizations option does have some activities that
would prohibit a backup at the same time as when that part
of the plan is run - e.g. the option to remove unused space
just does a dbcc shrinkdatabase and you can't run this and a
backup at the same time.
The best way to solve it is to just write your own jobs to
perform your maintenance. This allows a lot more control,
flexibility with your database maintenance.
-Sue
On Mon, 29 Mar 2004 15:26:08 -0800, "Amy Miller"
<amiller1@.sonomacourt.org> wrote:

>I've been pulling my hair over this message in my daily backup log...
>I found an article for this error message in knowledge base (274743), and i
t has something to do with SMS database. But we do not use SMS. So, I don'
t know how to solve this problem...
>This error moves around every day... sometimes Master doesn't get backed u
p, sometimes model...
>I'm not 100% sure, but maybe it started after I started to run optimization
job...
>I'd appreciate any help on this... Thank you!
>[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3023: [Microsoft][ODBC
SQL Server Driver][SQL Server]Backup, CHECKALLOC, bulk copy, SELECT INTO, and f
ile manipulation (such as CREATE FILE) operations on a database must be serialized.
Reissue the stateme
nt after the current backup, CHECKALLOC, or file manipulation operation is completed.[color
=darkred]
>[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operat
ion terminating abnormally.[/color]

No comments:

Post a Comment