<div>
listening &amp;&nbsp;learning
</div>


<div>
I am pretty sure that I cannot do the backup while the optimization is running but I gave it plently of time to finish before beginning the backup. &nbsp;It will still error out.
</div>


I am pretty sure that I cannot do the backup while the optimization is running but I gave it plently of time to finish before beginning the backup.  It will still error out.

<div>
I think this may be due to an outside netbackup that is occuring at the same time.
</div>


I think this may be due to an outside netbackup that is occuring at the same time.

<div>
<div class="content wysiwyg-content">
I have had issues with the Database Maintenance Plans tool. &nbsp;Sometimes the optimization fails with the error '[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.'<br />
<br />
What does this mean? &nbsp;And it seems to occur inconsistently.
</div>
</div>


I have had issues with the Database Maintenance Plans tool.  Sometimes the optimization fails with the error '[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.'

What does this mean?  And it seems to occur inconsistently.

SQL Database Maintenance error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.