Full Backup and Log backup timing

Hi
When I set up a schedule to backup my database and Tlogs, will I then have
to ensure that the database backup has finished before my Tlog backup job
starts? Will it create any problems if the database backup job is still
running when the Tlog backup job kicks in. Is it somethnig I should avoid
happening if possible?
Regards
SteenSteen
In my copmpany we do every night a complete backup of the database (let me
say at 01 am) and log backup we begin at 8 am in the morning. First thing i
get an email or even sms whether or not the full backup was complete
successful.
You will have to make sure that your full database was successful before the
log backup will start.
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> Hi
> When I set up a schedule to backup my database and Tlogs, will I then have
> to ensure that the database backup has finished before my Tlog backup job
> starts? Will it create any problems if the database backup job is still
> running when the Tlog backup job kicks in. Is it somethnig I should avoid
> happening if possible?
> Regards
> Steen
>|||I believe that one of the enhancements in SQL2K is that you can do a log backup while the db backup is
running, something you couldn't do in prior releases.
A quick test seem to confirm that, but of course a quick test in this case is not conclusive...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> Hi
> When I set up a schedule to backup my database and Tlogs, will I then have
> to ensure that the database backup has finished before my Tlog backup job
> starts? Will it create any problems if the database backup job is still
> running when the Tlog backup job kicks in. Is it somethnig I should avoid
> happening if possible?
> Regards
> Steen
>|||Unfortunately 2000 does not allow this yet either. You can start a Tlog
backup while a Full backup is in progress but it can not finish until the
Full is done. There is no problem doing this as far as errors and such.
--
Andrew J. Kelly SQL MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> I believe that one of the enhancements in SQL2K is that you can do a log
backup while the db backup is
> running, something you couldn't do in prior releases.
> A quick test seem to confirm that, but of course a quick test in this case
is not conclusive...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> > Hi
> >
> > When I set up a schedule to backup my database and Tlogs, will I then
have
> > to ensure that the database backup has finished before my Tlog backup
job
> > starts? Will it create any problems if the database backup job is still
> > running when the Tlog backup job kicks in. Is it somethnig I should
avoid
> > happening if possible?
> >
> > Regards
> > Steen
> >
> >
>|||Ahh, thanks Andrew!
The database I tested on is only 50 MB in size, I didn't see that wait in there...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message news:uxyW$$5UEHA.644@.tk2msftngp13.phx.gbl...
> Unfortunately 2000 does not allow this yet either. You can start a Tlog
> backup while a Full backup is in progress but it can not finish until the
> Full is done. There is no problem doing this as far as errors and such.
> --
> Andrew J. Kelly SQL MVP
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> > I believe that one of the enhancements in SQL2K is that you can do a log
> backup while the db backup is
> > running, something you couldn't do in prior releases.
> > A quick test seem to confirm that, but of course a quick test in this case
> is not conclusive...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> > > Hi
> > >
> > > When I set up a schedule to backup my database and Tlogs, will I then
> have
> > > to ensure that the database backup has finished before my Tlog backup
> job
> > > starts? Will it create any problems if the database backup job is still
> > > running when the Tlog backup job kicks in. Is it somethnig I should
> avoid
> > > happening if possible?
> > >
> > > Regards
> > > Steen
> > >
> > >
> >
> >
>|||Thanks for your input.
Regards
Steen
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> skrev i
en meddelelse news:%23D%23S2D6UEHA.3428@.TK2MSFTNGP12.phx.gbl...
> Ahh, thanks Andrew!
> The database I tested on is only 50 MB in size, I didn't see that wait in
there...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uxyW$$5UEHA.644@.tk2msftngp13.phx.gbl...
> > Unfortunately 2000 does not allow this yet either. You can start a Tlog
> > backup while a Full backup is in progress but it can not finish until
the
> > Full is done. There is no problem doing this as far as errors and such.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> > > I believe that one of the enhancements in SQL2K is that you can do a
log
> > backup while the db backup is
> > > running, something you couldn't do in prior releases.
> > > A quick test seem to confirm that, but of course a quick test in this
case
> > is not conclusive...
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > > http://www.solidqualitylearning.com/
> > >
> > >
> > > "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> > news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> > > > Hi
> > > >
> > > > When I set up a schedule to backup my database and Tlogs, will I
then
> > have
> > > > to ensure that the database backup has finished before my Tlog
backup
> > job
> > > > starts? Will it create any problems if the database backup job is
still
> > > > running when the Tlog backup job kicks in. Is it somethnig I should
> > avoid
> > > > happening if possible?
> > > >
> > > > Regards
> > > > Steen
> > > >
> > > >
> > >
> > >
> >
> >
>