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 bac
kup 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 i
s 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.p
hx.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...
have[vbcol=seagreen]
job[vbcol=seagreen]
avoid[vbcol=seagreen]
>|||Ahh, thanks Andrew!
The database I tested on is only 50 MB in size, I didn't see that wait in th
ere...
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@.tk2msf
tngp13.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 i
n
> message news:OTMBA45UEHA.1048@.tk2msftngp13.phx.gbl...
> backup while the db backup is
> is not conclusive...
> news:%239tFPa5UEHA.3988@.tk2msftngp13.phx.gbl...
> have
> job
> avoid
>|||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...
the[vbcol=seagreen]
in[vbcol=seagreen]
log[vbcol=seagreen]
case[vbcol=seagreen]
then[vbcol=seagreen]
backup[vbcol=seagreen]
still[vbcol=seagreen]
>