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 :)
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
~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~
~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
