Posted by Erland Sommarskog on 04/24/07 22:33

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: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
• Prev in forum: Re: Trigger: To fill another Database with using Stored Procedures of the other Database
• Thread view: Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K

[Reply to this message]