Friday, February 24, 2012

Backup and DTS....@ the same time....

I am launching full backup of user database and at the same time loading the
data to the tables using a DTS package. Will this be a performance issue?
I am using SQL2K.
Thanks,
CarlWell, it will potentially slow down both the load and the backup a little,
mostly simply because of the disc io involved. But is it an issue? - depends
on manythings - how biug the db is, how long the backup takes, how many rows
DTS is loading etc.
You will need to consider things like how long do the 2 steps take
seperately, how long together?, when is it happening? - will anyone else
know - ie is the db idle anyway when you do this?
Mike John
"Carl San" <Carl_San@.hotmail.com> wrote in message
news:un0FX8aMFHA.244@.TK2MSFTNGP12.phx.gbl...
>I am launching full backup of user database and at the same time loading
>the
> data to the tables using a DTS package. Will this be a performance issue?
> I am using SQL2K.
> Thanks,
> Carl
>

No comments:

Post a Comment