Posted by Rico on 04/24/07 22:44

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@sommarskog.se> wrote in message
news:Xns991D5A7E496DYazorman@127.0.0.1...
> Rico (me@you.com) 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@sommarskog.se
>
> 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

• Next in forum: Re: Populate table with stored proc
• Prev in forum: Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
• Thread view: Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K

[Reply to this message]