athar | SQLServerCentral

athar

Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

RE: MS SQL Bulk Copy Program (BCP) Issue: SQL becomes incapable of serving web pages when carrying out BCP procedure.

Thanks once again for your valuable answers.

May 2, 2011 at 7:07 am

#1318377
RE: MS SQL Bulk Copy Program (BCP) Issue: SQL becomes incapable of serving web pages when carrying out BCP procedure.

Oliiii (5/2/2011)
If both DBs are on the same disk you might get timeout simply because the disk can barely keep up with the BCP in and has not much time...

May 2, 2011 at 6:13 am

#1318350
RE: MS SQL Bulk Copy Program (BCP) Issue: SQL becomes incapable of serving web pages when carrying out BCP procedure.

Oliiii (5/2/2011)
Are you using the SQL Server mirroring feature or are the 2 DB independent and manually synchronized?
Are the 2 dbs on different disks/LUN (using a SAN or direct attach)?
You...

May 2, 2011 at 5:39 am

#1318338

Viewing 3 posts - 1 through 3 (of 3 total)