Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-15 : 07:49:45
|
| Ian writes "I have a question: We have an VB6.exe file which creates DTS package and executes it against TERDATA database the .exe program located at the web server physical package located at database server (web server and database serverlocated at the different machines). When .exe file running (it is scheduled) at the same time on database server a full database back is performed ( including master, model, msdb and our work database), also the transaction is pretty large around 360 000 records and sometimes the execution is hang for some reason (no error is reported). My question is can db backup contribute to this problem?" |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-15 : 08:02:58
|
| Backing up a database concurrently with it being busy shouldn't be a problem - it might slow some things down a bit, but I would not have expected it to be enough to stop things working.Kristen |
 |
|
|
|
|
|
Running DTS package during backups.