Is there a difference between performing a database back up using the maint
plan(xp_sqlmaint) or using the BACKUP command?
Does the xp_sqlmaint perform a FULL backup including the trans logs? And is
it performing a BACKUP LOG? (I would assume no it's not doing a backup log).
Is correct to say the both ways of db backups methods can be used to restore
a database to the point of that backup?
The only difference I note is that the main plans creates date/stamp and you
can keep several copies that you can see.It does a backup log if you tell it to backup the log. Otherwise it doesn't
backup the log. It does a full backup when you tell it to backup the db.
In both cases it uses the same BACKUP DATABASE or BACKUP LOG command that
you would use.
--
Andrew J. Kelly SQL MVP
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in
message news:3B2752D3-94DC-4136-8069-E33833DA37C5@.microsoft.com...
> Is there a difference between performing a database back up using the
> maint
> plan(xp_sqlmaint) or using the BACKUP command?
> Does the xp_sqlmaint perform a FULL backup including the trans logs? And
> is
> it performing a BACKUP LOG? (I would assume no it's not doing a backup
> log).
> Is correct to say the both ways of db backups methods can be used to
> restore
> a database to the point of that backup?
> The only difference I note is that the main plans creates date/stamp and
> you
> can keep several copies that you can see.
No comments:
Post a Comment