Database Backup and Backup in Database Maintenance

We are running SQL Enterprise Edition 2000 under Windows 2003 Standard
Edition server. Under Enterprise Manager, is there a difference between
the backup job setup under Databases, All Tasks, Backup Database and
Mangement, Database Management Plans. For some reasons, I am not able to
restore the backup file setup under Management, Data Management Plans.
Thanks.Hi Diane
I assume you mean the database maintenance plan rather than management plan?
If you set up a job using the backup wizard you will create a job that only
backs up the database. If you set up a maintenance plan it will set up one
or more jobs that can backup the database as well as re-index and do other
maintenance tasks on one or more databases.
If you wish to restore a database taken as part of a maintainance job, you
can us the restore wizard or the Restore T-SQL command in Query Analyser.
You may want to read "Designing a Backup and Restore Strategy" in Books
online regarding what you should have in place.
John
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:euTxi%23cYGHA.4760@.TK2MSFTNGP03.phx.gbl...
> We are running SQL Enterprise Edition 2000 under Windows 2003 Standard
> Edition server. Under Enterprise Manager, is there a difference between
> the backup job setup under Databases, All Tasks, Backup Database and
> Mangement, Database Management Plans. For some reasons, I am not able to
> restore the backup file setup under Management, Data Management Plans.
> Thanks.
>