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


Show quoteHide quote

Need help on Effective Reindexing Stragtegy.
Calculate Concurrent Users Between a Date/Time Range
ACT! installs 2nd instance no SA or Win-Admin access to..
Select performance is one table, but not another
DROPCLEANBUFFERS/FREEPROCCACHE
Managing TB size of data
Determine cause of Timeouts
Error 644 Severity level 21
Debug SP not stopping on Breakpoint
SQL Password... unknown