Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K

Thanks Erland,

I don't have a problem creating the T-SQL commands, it's using the
Enterprise Manager to do more than create dbs is where I get lost.

I will give that a try (creating a back up job and scheduling)

THanks!
Rick


"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns991D5A7E496DYazorman@xxxxxxxxxxxx
Rico (me@xxxxxxx) writes:
Thanks, but I should have mentioned that I'm using SQL 2000 and I'm not
using T-SQL, just trying to create the Maintenance plan from the
Enterprise Manager.

From what you described, you should not use a maintenance plan. Just set
up
a scheduled job to run the BACKUP statement. You can do this from the
GUI where you backup databases, and select Schedule somewhere on a button.
In the end you get a one-step job that has a BACKUP job.

Then again, if you have any interest in acquiring basic DBA skills, you
should certainly learn to write basic BACKUP commands in T-SQL.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
    ... I don't have a problem creating the T-SQL commands, ... Enterprise Manager to do more than create dbs is where I get lost. ... recent backup HAS to succeed before it'll delete the older one. ...
    (comp.databases.ms-sqlserver)
  • Re: Locate T-SQL Referenced by Job Step?
    ... I was looking for something complicated when in reality the T-SQL is the literal text string in the @command parameter! ... They'd used lower case 'backup log', I didn't recognize it straight away as T-SQL. ... any database. ...
    (microsoft.public.sqlserver.server)
  • Re: If statement in subqueries
    ... Have you tried re-writing the T-SQL to use a JOIN (as David and I ... >> Enterprise Manager and one of the builders to do their ... I hate those queries. ...
    (microsoft.public.sqlserver.server)
  • RE: xp_sqlmaint - how to determine the default directory
    ... The account is the database owner, but may not have sys-admin privileges. ... "Mike Epprecht (SQL MVP)" wrote: ... "Could not get the default backup ... >> I want to do this using t-sql. ...
    (microsoft.public.sqlserver.msde)
  • Re: Edit Identity Increment
    ... Enterprise manager, while performing the identity increment change, would be ... there is no way you can do without it using T-SQL. ... but if I could do it in a script it would simplify things greatly. ...
    (microsoft.public.sqlserver.server)