Try setting the maintenance plan with minimal settings (i.e. Try with ONLY the backup commands, and none of the optimization options turned on), then add bits and bobs slowly. Once you¹ve identified which specific settings are causing the problem, proceed with figuring that bit out.
On 2/28/08 9:44 AM, "Joseph L. Casale" <[EMAIL PROTECTED]> wrote: > Salvador, > The maintenance plan is given the following errors: > This one I get all the time: > [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed > because the following SET options have incorrect settings: > 'QUOTED_IDENTIFIER'. > These I get sporadically from different db¹s: > Backup can not be performed on database 'xxx'. This sub task > is ignored. > > Any ideas how to troubleshoot this? > > Thanks! > jlc > > > From: Salvador Manzo [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 26, 2008 4:30 PM > To: NT System Admin Issues > Subject: Re: Scripted SQL Backups > > MS SQL 2000 > Database Maintenance Plans > > MS SQL 2005 > Database Maintenance Wizard plus some custom SSIS tasks if you¹ll also be > doing differentials. (Microsoft made this interface needlessly confusing, > IMO). > > > SQLExpress (also applies to MSDE) > http://www.sqldbatips.com/showarticle.asp?ID=27 > http://www.sqldbatips.com/showarticle.asp?ID=29 > > MySQL > http://dev.mysql.com/doc/refman/5.0/en/backup.html > http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/ > > > On 2/26/08 3:17 PM, "Joseph L. Casale" <[EMAIL PROTECTED]> wrote: > I¹ll admit I have _never_ used sql am not sure what to do here. > > I have a slew of small DB¹s I need to script a nightly full of to a directory > which gets backed up to tape. > > Can someone push me in the right direction, being that I don¹t really know > anything about SQL, I don¹t know if the various points I am reading are > correct/optimal J > > Thanks! > jlc > > > > > > > > > ----- > Salvador Manzo [ 620 W. 35th St - Los Angeles, CA 90089 e. [EMAIL > PROTECTED] ] > Auxiliary Services IT, Datacenter > University of Southern California > 818-612-5112 > The injury which may possibly be done by defeating a few good laws, will be > amply compensated by the advantage of preventing a number of bad ones. -- > Alexander Hamilton, Federalist No. 73 on the veto power > > > > > > > > > > ----- > Salvador Manzo [ 620 W. 35th St - Los Angeles, CA 90089 e. [EMAIL > PROTECTED] ] > Auxiliary Services IT, Datacenter > University of Southern California > 818-612-5112 > --- > "Sometimes it is said that man can not be trusted with government of himself. > Can he, then, be trusted with the government of others? Or have we found > angels in the forms of kings to govern him? Let history answer this question." > -- Thomas Jefferson (First Inaugural Address, 3/4 1801) ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
