Data pump.... and SQL Backup....

Currently I am not considering the overlapping duration of database backup
and data load (using DTS). What happens if the full back is running on SQL
Server and at the same time the data is being pumped using a DTS package?
Any advice? SQL 2K.
Thank you,
AlwinIt depends. If your data pump is rapidly adding data, it is possible that
the log could fill before the backup is complete. Be sure to have "enough"
space in the transaction log while the full backup is taking place.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Alwin Twain" <ATwain@.hotmail.com> wrote in message
news:uvyvTAzuFHA.992@.TK2MSFTNGP12.phx.gbl...
Currently I am not considering the overlapping duration of database backup
and data load (using DTS). What happens if the full back is running on SQL
Server and at the same time the data is being pumped using a DTS package?
Any advice? SQL 2K.
Thank you,
Alwin|||A full backup will actually do a mini log backup when it completes the full.
It marks in the log when it starts the full backup and when it ends. Then
it grabs any committed trans from the log in between that time and includes
that in the full backup file. So as long as the DTS finished before the
full backup finished it will be included when you restore it. If it didn't
finish in time but you did get another log backup after it finished you can
recover that as well.
--
Andrew J. Kelly SQL MVP
"Alwin Twain" <ATwain@.hotmail.com> wrote in message
news:uvyvTAzuFHA.992@.TK2MSFTNGP12.phx.gbl...
> Currently I am not considering the overlapping duration of database backup
> and data load (using DTS). What happens if the full back is running on SQL
> Server and at the same time the data is being pumped using a DTS package?
> Any advice? SQL 2K.
> Thank you,
> Alwin
>|||Thank you for the reply.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eN669HzuFHA.460@.TK2MSFTNGP15.phx.gbl...
> It depends. If your data pump is rapidly adding data, it is possible that
> the log could fill before the backup is complete. Be sure to have
"enough"
> space in the transaction log while the full backup is taking place.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Alwin Twain" <ATwain@.hotmail.com> wrote in message
> news:uvyvTAzuFHA.992@.TK2MSFTNGP12.phx.gbl...
> Currently I am not considering the overlapping duration of database backup
> and data load (using DTS). What happens if the full back is running on SQL
> Server and at the same time the data is being pumped using a DTS package?
> Any advice? SQL 2K.
> Thank you,
> Alwin
>sql