I have SQL 2005 and wanted to know if there is an SQL backup called
"Maintenance Backup" other than the Maintenance Plan backup? Thanks.

-- Carolyn

You can call a backup anything you want but there are really only two ways
to do a backup directly with SQL Server. Either you manually construct a
TSQL Script and run that in which case you can call it anything you want. Or
you use the built in Maintenance wizard which are the maintenance plans.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Carolyn" <Carolyn@discussions.microsoft.com> wrote in message
news:BA415961-6AF3-4D17-B5DB-DBAB72D39951@microsoft.com...
>I have SQL 2005 and wanted to know if there is an SQL backup called
> "Maintenance Backup" other than the Maintenance Plan backup? Thanks.
>
> -- Carolyn