SQL Database Backup and Transaction Log Backup

I do the database first because in full mode the log will be processed
and you have at that point in time a complete backup that will get you
back to where you were. Then I backup the logs at intervals after that
so I can use the full backup and logs to get back to a point in time.


Adam Clark wrote:
> When doing a full backup, is it best to backup the logs first or the
> database?
>
> thanks
>
>

--
Brett I. Holcomb
brettholcomb@R777bellsouth.net
Remove R777 to email

I do the database first because in full mode the log will be processed
and you have at that point in time a complete backup that will get you
back to where you were. Then I backup the logs at intervals after that
so I can use the full backup and logs to get back to a point in time.


Adam Clark wrote:
> When doing a full backup, is it best to backup the logs first or the
> database?
>
> thanks
>
>

--
Brett I. Holcomb
brettholcomb@R777bellsouth.net
Remove R777 to email

Always perform full backup first before applying log backups

"Brett I. Holcomb" wrote:

> I do the database first because in full mode the log will be processed
> and you have at that point in time a complete backup that will get you
> back to where you were. Then I backup the logs at intervals after that
> so I can use the full backup and logs to get back to a point in time.
>
>
> Adam Clark wrote:
> > When doing a full backup, is it best to backup the logs first or the
> > database?
> >
> > thanks
> >
> >
>
> --
> Brett I. Holcomb
> brettholcomb@R777bellsouth.net
> Remove R777 to email
>

Always perform full backup first before applying log backups

"Brett I. Holcomb" wrote:

> I do the database first because in full mode the log will be processed
> and you have at that point in time a complete backup that will get you
> back to where you were. Then I backup the logs at intervals after that
> so I can use the full backup and logs to get back to a point in time.
>
>
> Adam Clark wrote:
> > When doing a full backup, is it best to backup the logs first or the
> > database?
> >
> > thanks
> >
> >
>
> --
> Brett I. Holcomb
> brettholcomb@R777bellsouth.net
> Remove R777 to email
>