我用SqlBulkCopy的恢复从XML备份表。其中一个表备份的是〜200MB大,有很多的记录。
我有错误:
超时过期。
超时时间已过之前,操作或服务器完成
没有响应。
解决方案
您可能需要增加超时。尝试增加值sqlBulkCopy.BulkCopyTimeout从30秒的默认。
I'm using SqlBulkCopy to restore tables from xml backups. One of the table backup is ~200MB large and has a lot of records.
I'm having error:
Timeout expired.
The timeout period elapsed prior to completion of the operation or the server
is not responding.
解决方案
You probably need to increase the timeout. Try increasing the value of sqlBulkCopy.BulkCopyTimeout
from the default which is 30 seconds.