Database backup and maintenance plan

In EM, what are the diffeneces between these two under the Management folder
?
I can schedule the database backup in Backup and also can schedule the
database schedule in Database Maintenance Plans ?
I set up the full backup and schedule in 'BackUp', it can create the full
backup file in the directory but cannot view contents by right click the
item on the right pane of 'Backup' folder.
Different way of scheduling, quite simply. To understand why you cannot see backups created by maint
plan, read about sp_addumpdevice. Main plan doesn't create backup devices, it addresses files
directly (see the BACKUP command and DISK = 'filename' option.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:%232W0oQCWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> In EM, what are the diffeneces between these two under the Management folder
> ?
> I can schedule the database backup in Backup and also can schedule the
> database schedule in Database Maintenance Plans ?
> I set up the full backup and schedule in 'BackUp', it can create the full
> backup file in the directory but cannot view contents by right click the
> item on the right pane of 'Backup' folder.
>
|||Another difference between the two is that the backup dialog box simply
allows you do create/schedule a backup..
The database maintenance plan wizard is intended to allow you to set up
several jobs which should cover most of your maintenance needs... not only
backups, but index maintenance, and dbcc checkdb...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:%232W0oQCWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> In EM, what are the diffeneces between these two under the Management
folder
> ?
> I can schedule the database backup in Backup and also can schedule the
> database schedule in Database Maintenance Plans ?
> I set up the full backup and schedule in 'BackUp', it can create the full
> backup file in the directory but cannot view contents by right click the
> item on the right pane of 'Backup' folder.
>
|||Thanks.
However, I have setup the backup device for the Northwind database for
example in the Management|Backup subfolder, and schedule the full and
differential backup for that, it can backup according to the schedule,
that's fine, BUT I cannot review the schedule of the backup that I created.
I had schedule the full backup at every Sunday and differential backup every
weekday at 5 pm, how do I review the schedule of these backup ?
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uXawQ%23EWEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Another difference between the two is that the backup dialog box simply
> allows you do create/schedule a backup..
> The database maintenance plan wizard is intended to allow you to set up
> several jobs which should cover most of your maintenance needs... not only
> backups, but index maintenance, and dbcc checkdb...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:%232W0oQCWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> folder
full
>
|||Look in the SQL Server agent folder. Each time you press "Schedule" in the backup dialog, a SQL
Server Agent job is created.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eaL4RSLWEHA.2928@.tk2msftngp13.phx.gbl...
> Thanks.
> However, I have setup the backup device for the Northwind database for
> example in the Management|Backup subfolder, and schedule the full and
> differential backup for that, it can backup according to the schedule,
> that's fine, BUT I cannot review the schedule of the backup that I created.
> I had schedule the full backup at every Sunday and differential backup every
> weekday at 5 pm, how do I review the schedule of these backup ?
>
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:uXawQ%23EWEHA.3472@.TK2MSFTNGP09.phx.gbl...
> full
>
|||Yes, I got it, thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ueqsT1OWEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Look in the SQL Server agent folder. Each time you press "Schedule" in the
backup dialog, a SQL[vbcol=seagreen]
> Server Agent job is created.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:eaL4RSLWEHA.2928@.tk2msftngp13.phx.gbl...
created.[vbcol=seagreen]
every[vbcol=seagreen]
simply[vbcol=seagreen]
up[vbcol=seagreen]
only[vbcol=seagreen]
Management[vbcol=seagreen]
the[vbcol=seagreen]
the
>