Differential Backup in Maintenance Plan?

Hello. Can you schedule a differential backup in a
Database Maint Plan? I didn't see any way to do that, so
my guess is this is a sqlwish type of thing? Unless
someone knows a trick? Thanks, BruceHello, Bruce!
Nope. Diff backups are not covered by the maint plan
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: Hello. Can you schedule a differential backup in a
: Database Maint Plan? I didn't see any way to do that, so
: my guess is this is a sqlwish type of thing? Unless
: someone knows a trick? Thanks, Bruce
-- Microsoft CDO for Windows 2000|||Hello, Bruce!
Nope. Diff backups are not covered by the maint plan
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: Hello. Can you schedule a differential backup in a
: Database Maint Plan? I didn't see any way to do that, so
: my guess is this is a sqlwish type of thing? Unless
: someone knows a trick? Thanks, Bruce
-- Microsoft CDO for Windows 2000|||ok Andy... Yep, a scheduled job would be fine. Just not
ALLLLLLL in the Maint plan then, oh well... Thanks, Bruce
>--Original Message--
>I thought I just saw Tibor answer this question a few
minutes ago. Oh well,
>no there is not a way to do it in the MP. Create your
own scheduled job and
>do it there.
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
>news:006401c34641$7daeeba0$a501280a@.phx.gbl...
>> Hello. Can you schedule a differential backup in a
>> Database Maint Plan? I didn't see any way to do that,
so
>> my guess is this is a sqlwish type of thing? Unless
>> someone knows a trick? Thanks, Bruce
>
>.
>|||Why not put ALLLLL the backups in your own scheduled jobs then to be
consistent. You have much better control over things if you don't use the
wizard and there really isn't anything the wizard can do that you can't with
a few lines of code.
--
Andrew J. Kelly
SQL Server MVP
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:0b4001c34647$70000e20$a001280a@.phx.gbl...
> ok Andy... Yep, a scheduled job would be fine. Just not
> ALLLLLLL in the Maint plan then, oh well... Thanks, Bruce
>
> >--Original Message--
> >I thought I just saw Tibor answer this question a few
> minutes ago. Oh well,
> >no there is not a way to do it in the MP. Create your
> own scheduled job and
> >do it there.
> >
> >--
> >
> >Andrew J. Kelly
> >SQL Server MVP
> >
> >
> >"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
> >news:006401c34641$7daeeba0$a501280a@.phx.gbl...
> >> Hello. Can you schedule a differential backup in a
> >> Database Maint Plan? I didn't see any way to do that,
> so
> >> my guess is this is a sqlwish type of thing? Unless
> >> someone knows a trick? Thanks, Bruce
> >
> >
> >.
> >|||Bruce
You can use the backup wizard to create a differential
backup, if you do not want to code it yourself, and keep
it consistent if you need to do more than one.
Regards
John

Differences between TSQL and SQL-92

Hi,
I guess there should be some differences between SQL Server's dialect
TSQL and strictily the SQL-92 standard.
For a researcg work I'm doing I need to collect and study this
difference, I've not found big things so far more than a few difference
in functions, unless my BNF lecture is failing.
Does anybody know an existing article that already put TSQL and SQL-92
face to face ?
Is there any big noticeable difference that you can cite here in this
newsgroup ?
Thanks in advance,Bunch of things. Which level of ANSI SQL -92? SQL Server supports the entry
level, but it also has a
load of stuff outside ANSI SQL 92. In SQL Server resource kit, there's a big
word doc which points
out whether each TSQL command adheres to ANSI SQL-92. Also, you can try the
SQL validator at
www.mimer.com.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<craigkenisston@.hotmail.com> wrote in message
news:1109363354.285681.136860@.f14g2000cwb.googlegroups.com...
> Hi,
> I guess there should be some differences between SQL Server's dialect
> TSQL and strictily the SQL-92 standard.
> For a researcg work I'm doing I need to collect and study this
> difference, I've not found big things so far more than a few difference
> in functions, unless my BNF lecture is failing.
> Does anybody know an existing article that already put TSQL and SQL-92
> face to face ?
> Is there any big noticeable difference that you can cite here in this
> newsgroup ?
>
> Thanks in advance,
>|||Why are you concerned with a standard that's obsolete:)|||>> Why are you concerned with a standard that's obsolete:) <<
Because the US Government says that SQL-99 and beyond are "Standards in
progress" and they want to see SQL-92 conformance? Because Microsoft
and the other big guys are *still* trying to come up to it?
Much of SQL-99 and SQL:2003 are like Algol-68, ADA and PL/I. Possible
to implement at great expense, but impossible for the average guy to
program with and doomed to produce horrible bulky code even for simple
tasks.|||--CELKO-- wrote:
>
> Because the US Government says that SQL-99 and beyond are "Standards in
> progress" and they want to see SQL-92 conformance? Because Microsoft
> and the other big guys are *still* trying to come up to it?
> Much of SQL-99 and SQL:2003 are like Algol-68, ADA and PL/I. Possible
> to implement at great expense, but impossible for the average guy to
> program with and doomed to produce horrible bulky code even for simple
> tasks.
>
--BEGIN PGP SIGNED MESSAGE--
Hash: SHA1
What about Ocelot DB? They claim to be compliant w/ SQL-99 and the
software is Open-Source (inexpensive?).
http://www.ocelot.ca/
"This is an uncrippled SQL:1999 database management system, an official
implementation of ISO standard SQL and ANSI standard SQL."
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
--BEGIN PGP SIGNATURE--
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/ AwUBQiKkPIechKqOuFEgEQI5kQCfSGyubHDnApwA
bmeOvPkGhEWOhwAAoOT7
nMt9jFhsUm7mAXhgEPORninN
=Gx9I
--END PGP SIGNATURE--|||MGFoster wrote:
> --CELKO-- wrote:
>
> --BEGIN PGP SIGNED MESSAGE--
> Hash: SHA1
> What about Ocelot DB? They claim to be compliant w/ SQL-99 and the
> software is Open-Source (inexpensive?).
> http://www.ocelot.ca/
> "This is an uncrippled SQL:1999 database management system, an official
> implementation of ISO standard SQL and ANSI standard SQL."
>
--BEGIN PGP SIGNED MESSAGE--
Hash: SHA1
On second reading of the ocelot site I believe I've been mislead by the
"SQL:1999" designation instead of "SQL-99." Ocelot's designation seems
to indicate that the product was finished in 1999, not that it is fully
SQL-99 compliant RDBMS.
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
--BEGIN PGP SIGNATURE--
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/ AwUBQiOe6IechKqOuFEgEQIl2gCfRdhJqAcXXSZb
N6RDhOg9tr7J78gAoIxr
oeMayceW7oem+/h1xBCm3lma
=UxGQ
--END PGP SIGNATURE--|||Are you Joe Celko ?
Well, I guess no other can reply with such authority :)
I recently ordered a couple of your books.
I wonder if you can make some recommendation on the following:
Im in a team working on the implementation of a query processor for a
propietary data format.
We need information specifically about the query processor
implementation in a database management system.
Besides the thousands articles in ACM and VLDB, which take very
specific topics, we have found just two books that cover this :
- Database Management Systems by Raghu Ramakrishnan
- Database Systems: The Complete Book by Garcia-Molina
Could you recommend other books on this topic ?
Thanks in advance !