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
Well, 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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment